Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am desesperately trying to move an expression with modifiers to a variable which I will load in my script with a let statement. For example:
I am aware that the expression: sum(Sales), can be moved to: let vSales = sum(Sales), so later on you can use it in the chart expression with the dollar expansion: $(vSales).
sum(Sales) --> vSales (with let statement) --> $(vSales)
However, how can I do the same with the folliwing expression with a modifier: sum({<[Region]='UK'>} Sales)?
Any comment is appreciated.
Thanks in advance.
JM Balaguer
SET vSalesUK = sum({<[Region]={'UK'}>} Sales);