Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
My condition for set analysis for previous year is not working can you please suggest on this.
Below is the condition,
if((Sum({<Head = {'Bcone'},FlagNum = {"$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},Month_Num={'<=$(=max(Month_Num))'}>}Attrition))
=0,
((Sum({<Head = {'Bcone'},FlagNum = {"$(vAttriationFlagNum)"},Year={'$(=(max(Year)-2))'},Month_Num={'<=$(=max(Month_Num))'}>}Attrition))),
((Sum({<Head = {'Bcone'},FlagNum = {"$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},Month_Num={'<=$(=max(Month_Num))'}>}Attrition)))))
if((Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},
Month_Num={"<=$(=max(Month_Num))"}>}Attrition))
i think you can also try Year without ' quotes Year={$(=(max(Year)-1))}
Hi Vineeth,
Month_num is still not working
thanks
Strange, does max(Month_Num) evaluate correctly in a text box? ARE both Numeric fields?
try below :
if(Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={$(=(max(Year)-1))}
,Month_Num={"<=$(=max(Month_Num))"}>}Attrition)=0, //Then
Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={'$(=(max(Year)-2))'}
,Month_Num={"<=$(=max(Month_Num))"}>}Attrition), //Else
Sum({<Head = {'Bcone'},FlagNum = {"=$(vAttriationFlagNum)"},Year={'$(=(max(Year)-1))'},
Month_Num={"<=$(=max(Month_Num))"}>}Attrition)
)
Hi All,
Year={'$(=(max(Year)-1))'} is not working in set analysis here
Thanks
Try this:
Year = { $(= max(Year)-1)) }