Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried to add variable in place of expression, lets say for
Exp1=sum() I created a variable ..with vSum=Sum(field),
but the problem is ..the vsum is not according to the dimensions..it is coming as a total for the whole field.?
I need to do this because I want to add triggers using variables.
please help.
Hi
In your load script, define vSum using Set, not Let:
Set vSum = Sum(Field);
Then in your expression, use
=$(vSum)
If that is still not respecting the dimensions, then its possible that the dimensions are not properly associated with [field] in your data model.
HTH
Jonathan
if you writ set vsum ...
and use your variable in the expression it will be computeddinamically according to the object you use
Hi
In your load script, define vSum using Set, not Let:
Set vSum = Sum(Field);
Then in your expression, use
=$(vSum)
If that is still not respecting the dimensions, then its possible that the dimensions are not properly associated with [field] in your data model.
HTH
Jonathan
Thanks Guys, it
worked