Set Anlaysis issue

[Anonymous]

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

[sunny_talwar]

You probably would need to do that within your variables

vProjectPipelineM2

and

vProjectPipeline#

and here

Sum({<YearMonth>} Aggr(.....

[miguelbraga]

Try simply this:

sum({$<YearMonth= >} aggr( rangeavg(above( $(vProjectPipelineM2)/$(vProjectPipeline#),0,3) ),Ring,YearMonth))

Best regards,

D.A. MB

[Anonymous]

Try to put {$<YearMonth= >} in front of the aggr function.  That should work.