Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created the following expression in a text object and it is working well
=num((Sum({<[NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >}[AMOUNT]))
Now I have also created a variable as follows
EPremium = (sum( {<NOTE = {'100'}>}[AMOUNT]*-1 ))
I want to apply above variable into my expression. Please help me Thanks in Advance
Hi,
If you want to give explicit selection by variable, then you can follow exactly like this:
=num((Sum({<EPremium ={'$(createdVariableName)'} , [NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >}[AMOUNT]))
select a text box and insert below
=EPremium
Do you mean you want to add DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= into the variable?
I would create a MyVariable variable for DEPT={'BRAN'},MONM={'MOTOR'},BRANCH=
and then add that into my Expression,something like
(sum( {<NOTE = {'100'}, $(MyVariable)>}[AMOUNT]*-1 ))
My real requirement is to insert variable into this
=num((Sum({<[NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >))
Hi,
If you want to give explicit selection by variable, then you can follow exactly like this:
=num((Sum({<EPremium ={'$(createdVariableName)'} , [NOTE]={100},DEPT={'BRAN'},MONM={'MOTOR'},BRANCH= >}[AMOUNT]))