Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My following set expression does not produce the expected result.
=NUM({<DEPT={'CITY'},MONTH={'JUL'}>}$(vNetClaim),'#,##0.')
This set moidifier I think is not in the correct place. pls correct me
There is an aggregation missing then set analysis worked only within them, maybe you could change your expression to:
=NUM(only({<DEPT={'CITY'},MONTH={'JUL'}>} $(vNetClaim)),'#,##0.')
- Marcus
Thanks
It is still not working
But this part works well =NUM ($(vNetClaim),'#,##0.')
How looked $(vNetClaim)?
- Marcus
vNetClaim=sum(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))
You couldn't use your variable in this way - your expression should be look like:
num(sum({<DEPT={'CITY'},MONTH={'JUL'}>}
rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)),'#,##0.')
- Marcus