SET EXPRESSION

[upaliwije]

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

[marcus_sommer]

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

[upaliwije]

Thanks

It is still not working

But this part works well      =NUM ($(vNetClaim),'#,##0.')

[marcus_sommer]

How looked $(vNetClaim)?

- Marcus

[upaliwije]

  vNetClaim=sum(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))

[marcus_sommer]

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