This content has been marked as final. Show 3 replies
1 of 1 people found this helpful
You Can change the calculation as:
IF [Store Status] = "EXISTING"
THEN [Target Sales EXISTING Store]
ELSE sum([Target Sales for NEW Store])
Thanks to your help.
Already marked this into correct answer.