Supress Null Values in Expression

[#1]

Hi Experts

I need to suppress Null Values in Expression.

PFA.

Regards

Eric Paul

[#2]

Anyone has ever faced this kind of thing.

Kindly help.

[Anonymous]

I doubt, that you can do, becoz same expression is having value under another column...

[#4]

Does it have a workaround

Nothing is impossible.

Yes, there are some limitations for that we have workarounds.

I've tried this thing. Now, I just have to supress the Null Values.

[rubenmarin]

Hi Eric, the expressions will be repeated for each vertical dimension, If you can't get a better answer, a workaround can be to reproduce the relation between Test and expressions in script and only only expresions checking these values.

Please check attachment to get the idea.

[roger_stone]

You could make the show of the column conditional based on the sum, or you could put zeros in by doing something like this in each expression:

=if(valuelist('ABC', 'XYZ')='XYZ',ALT(sum(Amount)),0)

[#7]

Thanks for the Reply.

But still the same result. I am not able to suppress Zeros.

[Kushal_Chawda]

You can do it from back end like attached.

See the attached application