Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
Please help me with idea how to get selected count of my field in inherited state for state2
=if(GetSelectedCount(Campaign2)=0, 'All',
if(GetSelectedCount(Campaign2)<3, Concat({state2} DISTINCT(Campaign2),', '),
'(' &count({state2} DISTINCT Campaign2) &') Campaigns'))
For example working expression:
=num(avg({state2<oDate={">=$(=date(vStart1,'DD/MMM/YYYY'))<=$(=date(vEnd1,'DD/MMM/YYYY'))"}>} TOTAL <oDate> [Purchase Horizon Score]),'#,##0.0')
Thanks,