expression in the script

[adiarnon]

hi,

i have a inline table that i need to use the _Measure in my model as a expression-

i added a text box with = _Measure and its giving me the text and not the resault of the expression

[_VIEW_N,_Measure

1,num(SUM(USD_AMNT_BY_PO_RATE)/1000,'#,##0')

2,num(count( ORDER_NO),'#,##0')

3,num(count(distinct ORDER_NO),'#,##0')

4,num(count(distinct BUYER_NAME),'#,##0')

5,num(count(distinct BP_CODE_CB),'#,##0') ];

what can i do?

adi

[#2 · Accepted solution]

$(=_Measure)

[Mark_Little]

HI,

You need to dollar expand as mentioned above.

If you call as you do you are asking for what is inside the variable i.e. the string for your formula.

When you dollar expand $(_measure) you are asking for the results of your formula.

Mark