Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I admit I always get confused with Nulls within Set Analysis.
Basically I got this situation, I got these rows, RECEIVED_DATE, ASSUM_CONSUM and DVALUE
I want the Sum of DVALUE and want to get all the NULL Values from RECEIVED_DATE and All the Values which are NOT NULL in ASSUM_CONSUM.
Any suggestions on how to do it?
Would I be on the right track if I do something like
Sum({-<RECEIVED_DATE={*}>}DVALUE)
Thanks a lot Steve
I think this document will help you.
Maybe something like....
Sum({<RECEIVED_DATE={''}, ASSUM_CONSUM-={''}>}DVALUE)
Hey Steve,
Please check out the attached file. I created a table with three expressions one is just a sum, other sum except null and third is sum for only null.
Hope it helps you
Thanks
AJ
Yes, you're on the right track.
File from Ajay Prabhakaran is a little better because it is explicit about 1 and $, but your version works too.
Thanks to all with the feedback and all of your suggestions helped.. It turned out that the requirement slightly changed but these were still good guidelines.
Thanks again