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,