Highlight the comparision of 2 margins
Hello
I am trying highlight a field when one margin is less than another is this possible , my code below doesn't work ?
=IIF(SUM(Fields!ActSales.Value-Fields!ActCost.Value))/Fields!ActSales.Value)<(SUM(Fields!BudSales.Value-Fields!BudCost.Value)/Fields!BudSales.Value))),
"Tomato","Moccasin")
ThanksKiwi_Wizz
May 8th, 2011 7:39pm
Hi
It looks like your formula contains a mixture of using SUM and not using SUM. I suspect you are missing SUM() around your divisors.
It also looks like you have incorrectly balanced your brackets in the first part of the formula (the two brackets at the end of the first SUM.
Craig Bryden - Please mark correct answers
Free Windows Admin Tool Kit Click here and download it now
May 8th, 2011 9:05pm