Aggregate function in num() under script

[#1]

Hi,

I'm facing syntax error while trying to reload after the below expression under Qlikview script,

if(POS_TYPE='Posted',num(sum(NOTIONAL)*-1,'###,###,###.##'),sum( ! !NOTIONAL)) as NETNOTIONAL

Please suggest the correct syntax or way forward for the same rather than implementing in UI and I have to use  in script only.

[sunny_talwar]

I think you might have to aggregate each of them in different  resident loads as my guess is that you are aggregating them on different levels. If you can share some data with expected output, I might be able to help you resolve your issue.

[#3]

Thanks sunny, I did aggregation  in different resident loads, now I got the result which I'm expecting,thanks much once again for your prompt response which really helped to resolve the same.

Thanks,

Mahesh

[sunny_talwar]

Awesome, I am glad it finally worked out for you.