Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using the following expression with cyclic group called @Cycle
AGGR(RANK(SUM({1}[charge-amount])) , $(=GetCurrentField([@Cycle])))
However my Fields are called Cust-Name and Charge-Description, so I need to put square brackets around this part of the expression
$(=GetCurrentField([@Cycle]))
Can anyone tell me the best way to do it.
Regards
Alan
May be this
$(='[' & GetCurrentField([@Cycle]) & ']')
Also, I have not tried this, but this might work as well
[$(=GetCurrentField([@Cycle]))]
Thanks, Both worked
Great, thanks for the confirmation