Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Yesterday I got some great help here so I try again.
I have a diagram (pivot) where I what one of the extression to select several values.
If I only whant onwe valu then this works:
=((sum({<[PD] = {'$(vCurrentPD)'}>} Belopp)))
But I whant a range of "PD" from 'startPD' to 'vCurrentPD'
=((sum({<[PD] = "From 'startPD' to vCurrentPD' Belopp)))
Any ideas?
Thank you
Jonny
Hi Jonny,
something like the below should work
Sum({$< PD = {'>=$(startPD) <=$(vCurrentPD)'}>} Belopp )
hope that helps
Joe
Hi Jonny,
something like the below should work
Sum({$< PD = {'>=$(startPD) <=$(vCurrentPD)'}>} Belopp )
hope that helps
Joe
Works perfektly, Thanks
no worries, glad to be of help, maybe check out this thread for a bit more info on set analysis
Set Analysis: syntaxes, examples
Joe