Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all.
I wish to simply exclude the current month from a chart.
I have a simple line chart showing a ratio of one status versus another but the current months data is skewing the chart.
Here is my expression:
=Count(If(ReferralAction = 'Denied', ReferralActions.InternalID))
/
Count(If(ReferralAction = 'Sent', ReferralActions.InternalID))
Many thanks
John
Not knowing what field you have for dates, I'd try two things off the top of my head..
First, if you never want to see the current month, why not set a trigger on the page that sets the "Month" field to all but the current month? Something like "Month < Month(today())"
Second, if you might want to see the current month, why not put a listbox on the page, and again set a trigger as above, but now if the user does want to see the current month, he can simply select it.
Not knowing what field you have for dates, I'd try two things off the top of my head..
First, if you never want to see the current month, why not set a trigger on the page that sets the "Month" field to all but the current month? Something like "Month < Month(today())"
Second, if you might want to see the current month, why not put a listbox on the page, and again set a trigger as above, but now if the user does want to see the current month, he can simply select it.