I have a challenge with if statements. I have a calculation that will calculate performance by Manager. That Achievement percentage I want to hook up to an if statement to say if RSM A = 90% then pay 500 , if RSM B = 100% then pay 1000.
The manager field is a dimension in my data
My current syntax evaluates the topline and not by RSM so when I do the if statement everybody gets the same payment. It looks like my syntax is ignoring the Dimension
