Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I need to suppress Null Values in Expression.
PFA.
Regards
Eric Paul
Anyone has ever faced this kind of thing.
Kindly help.
I doubt, that you can do, becoz same expression is having value under another column...
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.
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.
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)
Thanks for the Reply.
But still the same result. I am not able to suppress Zeros.
You can do it from back end like attached.
See the attached application