Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I have an expression that looks like this:
=Sum({[P1]*$<$(sIgnoreFieldsWF)>}[FC_HistoricalForecast])
The ignore fields variable is used to ignore selections in certain list boxes.
Now I also want to include in the set analysis that only values at max date should be summarized for FC_HistoricalForecast. (i.e. somthing like this: Sum({<[Date]={'$(=Max([Date])'}>} Value)
How do I combine this into the set analysis?
//Hoowling
How about this?
Sum({[P1] * $<$(sIgnoreFieldsWF), [FC_StoreDate] ={'$(=vMaxDateFC)'}>} [FC_HistoricalForecast])