Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - I have tried below 2 expressions.
1.sum(Aggr(Sum({<[Period]= {'P3'}>}([Area]/[Total Area])*Time), Key))
2.sum(Aggr(Sum({1<[Period]= {'P3'}>}([Area]/[Total Area])*Time), Key))
I want to lock the value to P3 meaning any period is selected from the list I dont want the value to change but as of now if I select other periods value goes to 0.
Any thoughts please ?
You probably need to put the set analysis in both of the sum() functions:
sum({<[Period]= {'P3'}>}Aggr(Sum({<[Period]= {'P3'}>}([Area]/[Total Area])*Time), Key))
You probably need to put the set analysis in both of the sum() functions:
sum({<[Period]= {'P3'}>}Aggr(Sum({<[Period]= {'P3'}>}([Area]/[Total Area])*Time), Key))
Its not working...out put is 0.
Can you post a sample file? Can't tell what's happening without seeing the document...
Are you selecting from the field "Period" or another field that also represents the period? If the latter you'll need to exclude it in your set analysis ie OtherField=
What happens with the inner Sum - does it evaluate properly when selecting the period?
Is your data model and data complete such that selecting a period links to all the data fields and nothing is missing? For example if there is no Time for your selected period then the expression will return 0.