variables issues

[vengadeshpalani]

Hi

I have created variable in script level when I use this variable in text object I face below issue... how can I modify variable?

set try = '=num(sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsReceived))/sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsExpected)),'#,##0.00%')' ;

[hic · Accepted solution]

You cannot nest single quotes like that. Try double quotes instead.

Set try = "= ... "

HIC

[ashwinishinde]

Dear vengadeshpalani,

          Try This

let try = num(sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsReceived))/sum({<[Interval Group]={'15-minute'},[Meter ID]= ,[Bill Group]= >}(aggr_IntervalsExpected)),'#,##0.00%') ;

Thanks & Regards,

Ashwini