Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
While writing his expression I am gettting an error that IF takes 2-3 parameters. What am I doing wrong?
if(
RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales) <=0.8, Green(255),
if(
RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales)) <=0.9, Yellow(255),
Red(255)
)
)
I see, One Parenthesis closed extra which is in red color. Try to remove that and see?
if(RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales) <=0.8, Green(255),
if(RangeSum(Above(sum(TotalSales),1,RowNo())) / Sum(TOTAL TotalSales)) <=0.9, Yellow(255),
Red(255)))