# [Resolved] Is it possible to change color of a numerical output if the result is negative?

This support ticket is created 9 years, 9 months ago. There's a good chance that you are reading advice that it now obsolete.
Sun Mon Tue Wed Thu Fri Sat
- 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 9:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Hong_Kong (GMT+08:00)

This topic contains 10 replies, has 2 voices.

Last updated by Luo Yang 9 years, 9 months ago.

Assigned support staff: Luo Yang.

Author
Posts
#174378

Hi there, this question follows on the discussion I started over here: https://toolset.com/forums/topic/need-to-limit-the-number-of-digits-output-from-a-calculation/#post-173568.

And I'm wondering if there's a way to output a negative calculation with a different color (red)?

#174593

Hi dbarber,

Could you describe more details for the question?
What is the negative calculation with a different color (red)?

#174901

Hi Luoy

What I'm hoping to be able to achieve is to automatically change the color of any calculation that's less than 0.00% to red.

Cheers

Dawson

#175029

I assume you are using such a custom shortcode in your theme/functions.php:
https://toolset.com/forums/topic/need-to-output-some-text-depending-on-the-output-of-a-calculation/#post-174033

```...
function number_format_filter_func(\$v)
{
return \$res = number_format(\$v, 2);
}
...
```

```...
function number_format_filter_func(\$v)
{
\$class = "my-normal";
if(\$v<0)\$class = "my-red";
return \$res = '<div class="' . \$class . '">' . number_format(\$v, 2) . '</div>';
}
...
```

```div.my-red{
color: red;
}
```
#175294
#175931

I suggest you try refer to the thread:
https://toolset.com/forums/topic/need-to-output-some-text-depending-on-the-output-of-a-calculation/#post-174033

modify it like this:

```add_shortcode('wpv-calculate', 'calculate_shortcode');
function calculate_shortcode(\$atts) {
extract( shortcode_atts( array(
'evaluate' => '',
'format_filter' => 'number_format_filter'
), \$atts ) );
\$res = wpv_condition(\$atts);
\$res = apply_filters(\$format_filter, \$res);
return \$res;
}

function number_format_filter_func(\$v)
{
function number_format_filter_func(\$v)
{
\$class = "my-normal";
if(\$v<0)\$class = "my-red";
return \$res = '<div class="' . \$class . '">' . number_format(\$v, 2) . '</div>';
}
}

function compare_format_filter_func(\$v)
{
\$res = 'C';
if(\$v<18)\$res= 'A';
if(\$v>18 && \$v<22)\$res= 'B';
//here you can add more conditions
return \$res;
}
```

div.my-red{
color: red;
}

#176378

Hi Luoy

Thanks very much for this. Unfortunately, the modified code seems to create an issue for the theme I'm using (Pagelines DMS): the front end page editor will not allow the page to load.

I've tried deactivating all plugins (except Toolset) and get the same result. I've tried on a couple of sites using Pagelines DMS and it happened on both of them.

No sure if there's an alternative approach, but, nevertheless, I really appreciate all of your help.

Dawson

#176380

Hey Luoy

How would I go about adding a second evaluation (on the same site) that functions basically the same way but uses different thresholds to determine which text is output.

So basically what I'm hoping to be able to do is have two distinct evaluations done so that I can apply them separately.

I tried to figure something out on my own (I basically just copied/pasted part of the code from above and then modified it a little), but just caused the site to go blank.

Here's what I did (it should make it clear what I need to be able to do):

```add_filter('compare_firstone_format_filter', 'compare_firstone_format_filter_func');
function compare_firstone_format_filter_func(\$v)
{
\$res = 'A';
if(\$v<18)\$res= 'B';
if(\$v>22)\$res= 'C';
//here you can add more conditions
return \$res;
}

function compare_secondone_format_filter_func(\$v)
{
\$res = 'A';
if(\$v<14)\$res= 'B';
if(\$v>21)\$res= 'C';
//here you can add more conditions
return \$res;
}```

And here's what I did with the shortcodes:

`[wpv-calculate evaluate="[types field="detached-sales-current" id="\$market-updates"][/types] / [types field="detached-active-listings-current" id="\$market-updates"][/types] * 100 " format_filter="compare_firstone_format_filter"]`
`[wpv-calculate evaluate="[types field="detached-sales-current" id="\$market-updates"][/types] / [types field="detached-active-listings-current" id="\$market-updates"][/types] * 100 " format_filter="compare_secondone_format_filter"]`

I'll continue to try to figure this out, but would really appreciate your help.

Many thanks

Dawson

#176652

Dawson. sorry,

```add_shortcode('wpv-calculate', 'calculate_shortcode');
function calculate_shortcode(\$atts) {
extract( shortcode_atts( array(
'evaluate' => '',
'format_filter' => 'number_format_filter'
), \$atts ) );
\$res = wpv_condition(\$atts);
\$res = apply_filters(\$format_filter, \$res);
return \$res;
}

function number_format_filter_func(\$v)
{
\$class = "my-normal";
if(\$v<0)\$class = "my-red";
return \$res = '<div class="' . \$class . '">' . number_format(\$v, 2) . '</div>';
}

function compare_format_filter_func(\$v)
{
\$res = 'C';
if(\$v<18)\$res= 'A';
if(\$v>18 && \$v<22)\$res= 'B';
//here you can add more conditions
return \$res;
}
```

div.my-red{
color: red;
}

#176740

Hi Luoy

I realized that I haven't done a good job asking for help because I have a few support threads open that I realized cannot be resolved independent of one another so I decided to start a fresh thread that combines all them.

Here's the new "all in one" thread: https://toolset.com/forums/topic/need-to-perform-4-different-calculations-on-the-same-website/

I really appreciate your excellent support and apologize for having taken up your time. I should have thought this through more fully before asking for assistance.

Cheers

Dawson

#176989

I have taken the thread you mentioned above