Using a IF Statement in a Member Formula
Trying to create a simple member formula. I want it to return a '0' if the member calculated is a negative number, but use the number calculated if it is positive.
"Enroll_Over_Target" (
IF (@ISMBR ("Enroll_Over_Target") < 0 )
"Enroll_Over_Target" = 0;
ELSE
"Enroll_Over_Target";
ENDIF;)
It should be simple, but keep getting an error saying I have a closed parentheses and not an open one in line 1, which obviously I have.
This is a Dynamic Calc member also of the Account dimension.
Tagged:
0