aggr with rangeavg

[krish2459]

Hi,

I'm trying to use the aggr with rangeavg but it is not working.

below is the logic.

num(aggr(RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating]),Timeline,'#,##0.0')))

Thanks..

[soniashaik]

Hi,

I think its because of the extra bracket please try this 

num(aggr(RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating]),Timeline,'#,##0.0'))

[Kushal_Chawda · Accepted solution]

looks some syntax error

num(aggr(RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating]),Timeline),'#,##0.0')))