Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I wish to show a table, but only show data where one of the fields is a different value from the previous month.
Example
=IF([Coverage Group (All)]<>({<[Reporting Date]={'$(=monthend(MAX([Reporting Date]),-1))'},[Coverage Group (All)],[Coverage Group (All)],''))
So if the value in the field [Coverage Group (All)] is different to the value from the previous month then show it otherwise null.
The above however does not work.
Hi,
A couple of thing:
=IF(Sum([Coverage Group (All)]) <>
Sum({<[Reporting Date]={"$(=monthend(MAX([Reporting Date]),-1))"} [Coverage Group (All)])
,Sum([Coverage Group (All)])
,'')
I can't test your formula, but try the above.
Jordy
Climber
Hi,
A couple of things:
=IF(Sum([Coverage Group (All)]) <>
Sum({<[Reporting Date]={"$(=monthend(MAX([Reporting Date]),-1))"} [Coverage Group (All)])
,Sum([Coverage Group (All)])
,'')
I can't test your formula, but try the above.
Jordy
Climber
[Coverage Group (All)] is a text field and no aggregation appears to work.
I have used single quotes using that set analysis previously and it works as expected on them
The below works:
=IF([Coverage Group (All)]<>[Coverage Group (Ext)],[Coverage Group (All)],'')
This is using a similar field.
Am I unable to use set analysis on if my field is text?