Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have multiple filters in a sheet, using which i want to display various data. There is one field 'Application Count' which i don't want to change whenever 'Month of Closed date' filter changes, but can change if other filters change.
If i use the expression - Count ({<Closeddate =>} [Application ID]), its not working, since i have created filter on Month of the closed date.
If i use the expression - Count ({<Month(Closeddate) =>} [Application ID]), its showing an error.
Any advise on how i go about this?
Yours Truly,
S.Manikantan
Hi,
Create a field CloseMonth in script and then use in your set analysis.
Count ({<CloseMonth =>} [Application ID])
Regards,
Kaushik Solanki
Thanks Kaushik. That works. I am trying to create another field apart from closed month to display only certain months as below:
if(ClosedMonth=month(addmonths(Today(1),-4)) and Year(Closeddate) = Year(Today(1)),ClosedMonth)
I am getting an error "Missing Right Paranthesis". But all brackets seem to be right. The same expression works in the expression editor.
Any thoughts on this?
Yours Truly,
S.Manikantan
Change this to a field. Year(Closeddate)
That should work.
Regards,
Kaushik Solanki
Thanks Kaushik.