Compare variables using IF statement in Set Analysis
I'm trying to get the code below to work. It works fine when using the line that is commented out -
if( (Business_GF_Old<>Business_GF) and (Report_Grouping_Old<>Report_Grouping),Constant,0)
However, I need these values to change dynamically with the values for vBus_Dim_Name_Old and vBus_Dim_Name. I've tried single quotes, double quotes, but can't get it to work. Any help is greatly appreciated. Thanks.
Sum (
{<
Hires={0},Terms={0}
>}if( ($(vBus_Dim_Name_Old) = $(vBus_Dim_Name)) and (Report_Grouping_Old<>Report_Grouping),Constant,0)
//>}if( (Business_GF_Old<>Business_GF) and (Report_Grouping_Old<>Report_Grouping),Constant,0)