Hey guys,
I am trying to create RAG rating with the below. It works when a field is selected but when nothing is selected it should turn grey. Instead it turns black! (Error in expression) can somebody help me fix this?
Im using Set analysis with a few variables, and cant seem to locate where the error is.
The formula i am using is below:
if
(
sum({<YM = {$(vYM)},R = ,P ={'$(vCP)'}>}ACR.#NUMBER_OF_ROWS) = 0
or
sum({<YM = {$(vYM)},R = ,P ={'$(vCP)'}>}ACR.#NUMBER_OF_ROWS) = 0
, RGB(vBLUE1,vBLUE2,vBLUE3),
if(
(round((100*sum({<YM={$(vYM)},P={'$(vCP)'}>}ACR.HOURS)
/
(sum({<YM={$(vYM)},P={'$(vCP)'}>}AC.FE)*$(='vHours'&'$(vPercentageChange)') ))/$(='vPercentage'&'$(vPercentageChange)')
,1))
>=$(='vThresACP_'& vPercentageChange &'_C07High')
,RGB(vRED1,vRED2,vRED3),
if(
(round((100*sum({<YM={$(vYM)},P = {'$(vCP)'}>}ACR.HOURS)
/
(sum({<YM={$(vYM)},P ={'$(vCP)'}>}AC.FE)*$(='vHours'&'$(vPercentageChange)') ))/$(='vPercentage'&'$(vPercentageChange)')
,1))
<=$(='vThresACP_'& vPercentageChange &'_C07Low')
,RGB(vGRE1,vGRE2,vGRE3)
,RGB(vYELL1,vYELL2,vYELL3)
)
)
)