
1. Re: Calculation Help
Mahfooj Khan Jun 6, 2016 5:54 PM (in response to Raja Saab)1 of 1 people found this helpfulIs 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.
Mahfooj

2. Re: Calculation Help
Raja Saab Jun 6, 2016 10:56 PM (in response to Mahfooj Khan)Mahfooj,
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)

3. Re: Calculation Help
msa s Jun 6, 2016 7:51 PM (in response to Mahfooj Khan)Hi Mahfooj,
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
LOOKUP(MAX([Value]),FIRST())>LOOKUP(MAX([Value]),LAST())
THEN 1

4. Re: Calculation Help
Mahfooj Khan Jun 6, 2016 8:07 PM (in response to msa s)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.