Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I would like to use A Cyclic Group (name:Group) das an Dimension and reuse this Selection in a Set Expression.
Like:
Sum(counter) / sum( Total <Group> counter) this is actually working!
But i exprected something like that.
Sum(counter) / sum( Total {<GetSelectet(xxxx)}>} counter)
Can anybody explain what is the correkt syntax and how to use it?
Thank you all
Markus
May be (just may be) you need this:
Sum(counter)/Sum(Total <$(='[' & GetCurrentField([GroupName]) & ']'))> counter)
Set expression or total qualifier? I am confused as to what you are looking for?
Hi,
I'm not sure what is here de different.
I will have the selection choosen in the cyclic group transfered or used into the formula.
Or the other way round - how can I use a formula dependent on the selected dimension.
Maybe these are two different things..
Regards,
Markus
May be (just may be) you need this:
Sum(counter)/Sum(Total <$(='[' & GetCurrentField([GroupName]) & ']'))> counter)
Looks good - I have to try it.
Nice trick....