oscargm_bi
Contributor III
2019-07-25
09:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Problems with color text in pivot table
Hi all,
I have this expression in a measure of a pivot table: if(avg([Importe Est. Moneda CTV]) > 44000,'red','green') that makes if the average of the "importe..." its > 44.000 turn red the value o green if its not.
Everything works fine, but when I add the Totals of the dimension, the data always turn in red without fulfill the conditional.
Attach there is a image of the problem.
Thanks in advance.
Regards
690 Views
1 Reply
juliensaintmaxent3113
Luminary Alumni
2019-07-25
09:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hello,
the total is correct?
I think you gotta to specify the dimension which you want to calcul the average condition avg(total <dim1,dim2,...>KPI)
Bye
682 Views