Forum Discussion
Counting Percentage problem.
The conditional formatting features don't currently support using measurse to determine the back/font colur.
You can use the code to generate arrows or other characters (thumbs up/down etc).
Let me know if you'd like help with that.
I figured out the first part. I created new measure and then I used the Calculate function as below.
Measure = calculate(sum(GoodSale)/TotalSale * 100)
This gives me the desired output in the last column.
The conditional formating is still outstanding. I don't know how to get that done. I have created another measure called ColorCode
ColorCode = if(%GoodSale > 70, "Green", "Red")
This gives additional column at the end that prints Green and Red based on the %GoodSale column value. However, I want to print the text "Green" in Green color and "Red" in Red color. How to get that done? Any idea? Thanks a lot.
The conditional formatting features don't currently support using measurse to determine the back/font colur.
You can use the code to generate arrows or other characters (thumbs up/down etc).
Let me know if you'd like help with that.