Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table in my application with a drill down group dimension. I have mapped in target values using a mapping load to my data set based on each of the dimensions in the group. I then have a variable that grabs the target value associated with whatever dimension is drilled in to. However, during the mapping load the Total targets don't come in since there is no "Total" in my dimension. I still need to display the total target on the total line so I am trying to use an IF statement to bring in the static total target if the row is 0 but I'm getting an error.
The variable works fine on its own in the expression but once I add the "If" it errors out saying its expecting a ')'. On the flip side if I use the If without the variable it also works fine. What am I missing??
The If I'm using is: =If(RowNo()=0, .87, $(vChgTarg_Org))
Yes that works perfectly. I never would have thought to use single quotes on the field in the variable.
Thanks!!!!