Why won't this work...

[samvile18]

...can anyone tell me why this won't work?

=sum({<Measure={'FUM'},FExtractDate={'$(=MonthEnd(MaxDate))'}>}Value)

MaxDate is a date field along with FExtractDate - I need to sum the FUM value where these two match.

[Miguel_Angel_Baeyens]

Sam,

Depending on the date values, it should be something like this

If(Measure = 'FUM' AND FExtractDate = MonthEnd(MaxDate), Sum(Value))

or

Sum(If(Measure = 'FUM' AND FExtractDate = MonthEnd(MaxDate), Value))

Hope that helps.

Miguel

[samvile18]

Neither of these are working so I'm beginning to think there must be an issue with the formatting of the dates