Set Analysis/IF/RAG assistance required

[#1]

  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)

)
)
)