Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys,
Want to create variable for below exp-
=if(CF_Month='Apr',
(Count(DISTINCT {<Flag={'Active'}, FYear={$(vtestYear)},CF_Month={$(vtestmonth)},Quarter=,FIN_Year=, O1andOE={'O1 & Above'},Location2-={'2004'}>} [Personnel No])),
(Count(DISTINCT {<Flag={'Active'}, FYear={$(VFYear)},CF_Month={$(vtestmonth)},FIN_MNT=,FYear=, O1andOE={'O1 & Above'},Location2-={'2004'}>} [Personnel No]))
)
Please help.
Thanks in advance
Priti, check the following Help link, if that does not help, please provide further context on things, as I am a bit confused, which means others likely are too, and that may be why nobody has answered already...
Regards,
Brett