Set Analysis syntax for excluding nulls

[#1]

Hi,

I got a pivot that sums total spend amount for various FY and I would like to exclude nulls from Sub Rollup without adding this field as dimension. Is this the correct syntax?

[sunny_talwar]

Is it true null or does it says NULL? For true null, try one of these:

{<DRVD_PRD_SUB_ROLLUP -= {'*'},....

or

{<DRVD_PRD_SUB_ROLLUP = e({<DRVD_PRD_SUB_ROLLUP = {'*'}>}),....

or

{<DRVD_PRD_SUB_ROLLUP -= {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

[#3]

Thanks Sunny! I'll try all three. Btw, what is the "e" for in this example?

{<DRVD_PRD_SUB_ROLLUP = e({<DRVD_PRD_SUB_ROLLUP = {'*'}>}),....

[sunny_talwar · Accepted solution]

I think, I might have made a mistake with the 1st two... try these

{<DRVD_PRD_SUB_ROLLUP = {'*'},....

or

{<DRVD_PRD_SUB_ROLLUP -= {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

[sunny_talwar]

e means exclude and p mean possible. Look at the attached document for more details on e and p

[#6]

So these two will exclude true null DRVD_PRD_SUB_ROLLUP ?

[#7]

<DRVD_PRD_SUB_ROLLUP = {'*'},.... worked but the others did not.

[sunny_talwar]

I left the - negative sign by mistake... should have been this

{<DRVD_PRD_SUB_ROLLUP = {"=Len(Trim(DRVD_PRD_SUB_ROLLUP )) > 0"},....

[#9]

Oh ok. Thanks!