Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I am trying to do a set analysis for a distinct month, could you help me sort it?
=if(Headcount<>Null(), count({<Month={'Jan'}>}distinct Employee))
Thanks,
Anna
May be
Count({<Month={'Jan'}, Headcount = {*}>}Distinct Employee))
Hi,
Try this,
create flag in your script.
Like
if(isnull(Headcount),'false','true') as Headcount_Flag;
Then use set analysis
like this,
count({<Month={"Jan"},Headcount_Flag={'true'}>} Distinct Employee)
regards,
Try like
=count({<Month={"Jan"},Headcount = {'$(=len(Headcount)<>0)' }>} Distinct Employee)
Or
=count({<Month={"Jan"},Headcount = {*} >} Distinct Employee)
Thank you!