Referencing a field within a function, within a Set Analysis

[#1]

Hi,

I have the following expression:

=

SUM({$<Data.ReportMonth1=, [Report Calendar.FinancialYear]=, MonthYear={"$(=Text(Date(AddMonths(Date#(vReportDate,'MMM YYYY'),MIN(Data.QtrReportAdj)),'MMM YYYY')))"}>}Data.QuarterActual

)

My problem seems to be when I'm trying to adjust the date. From what I can tell is happing, is the MIN(Data.QtrReportAdj) seems to be applying to all my measures, rather than just the measure.

In the example attached, if you filter by the A&E 4 hr target(excludes walk-in centres), it works fine.

Hope this makes sense.

Thank you in advance,

Simon

[luciancotea]

Set analysis is evaluated once for all rows, not for each row.

[#3]

Hi,

Sorry, but im a bit confused.

If I replace MIN(Data.QtrReportAdj) with -3, I get the answer for each measure, so the Set analysis works for each row. I dont get the sum off all measures.

Can you expand on what you mean

Cheers

[#4]

Hi,

Sorry, but im a bit confused.

If I replace MIN(Data.QtrReportAdj) with -3, I get the answer for each measure, so the Set analysis works for each row. I dont get the sum off all measures.

Can you expand on what you mean

Cheers

[luciancotea]

Again, MIN(Data.QtrReportAdj) is evaluated once and the evaluation = -6.

You can see the expression evaluation result if you remove the label of the expression. See attachment.

[simondachstr]

I think at this point you will need to introduce min(Data.QtrReportAdj) as new field in your data model.