Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I Have an issue with a rangeavg calculation. I use a moving average with the rangeavg function:
sum(aggr( rangeavg(above( $(vProjectPipelineM2)/$(vProjectPipeline#),0,3) ),Ring,YearMonth))
This works fine. But now I want to exclude YearMonth (as with YearMonth=) from the selections as this will recalculate from selecting fields. That's unwanted. Were do I put thise exclusion in the set analysis?
Pls advice
Robert
You probably would need to do that within your variables
vProjectPipelineM2
and
vProjectPipeline#
and here
Sum({<YearMonth>} Aggr(.....
Try simply this:
sum({$<YearMonth= >} aggr( rangeavg(above( $(vProjectPipelineM2)/$(vProjectPipeline#),0,3) ),Ring,YearMonth))
Best regards,
D.A. MB
Try to put {$<YearMonth= >} in front of the aggr function. That should work.