Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the following expression (TEXT OBJECT):
=sum(aggr(count(distinct if( CalendarMonthName= vCurrentMonth and CalendarYear = vCurrentYear,[Message Person ID])),Date))
I want to make it fixed value so it should only show the output for CalendarMonthName= vCurrentMonth and CalendarYear = vCurrentYear and should not get updated even I make any field selections in the application.
Thanks,
H
You can try this:
=sum(aggr(count(distinct {1<CalendarMonthName= {"$(=vCurrentMonth)"} and CalendarYear = {"$(=vCurrentYear)"}>} [Message Person ID]),Date)
I think aggr function isnt required as your are using in text box. If you have any specific reason ignore this comment.
Regards,
Kiran Rokkam.