1 of 1 people found this helpful
Is that what you wanted?
If actuals > budget then actuals green else budget red vice verse. I've done some hack to get the percentage because your actual and budget both are in same columns.
Workbook has been published in my public profile. Have a look.
Feel free to ask If you've any question.
Many Many thanks for the response. I am currently traveling reaching my destination quite late in the night. I saw the workbook and looks like this is exactly what i wanted to achieve. I will download and check it out to my Tableau environment and let you know incase i have questions!
Once again - many thanks
- Vivek (Raja)
Could you explain about this ,
you are searching up for the max value from first and checking with max value from last row ,why you are evaluating to 1
and also can you share xls sheet ?
IF ATTR([Value Type])='Actuals' AND
If you see the last line of requester's requirement where requester wants
to color the actual If its above budget. Integer is much faster then string
in calculations. So make it more efficient I've used integer. I hope you
get my point.