Forum

This content is now out of date.

Visit Our Community

NULL as Zero option not in Normal Tab

Hi,

We created a report with a line chart.
We have some null values and we wanted to map them to zero.

We got the following option in a cross tab report:

Cross Tab Report:
Forum image

Option is Available in Cross tab:
Forum image

Normal Report:
Forum image

No null as Zero option in Normal Tab:
Forum image

Kindly let us know if we are missing any option to get the same.

Thanks & Regards,
Prateek
Hello Prateek,

You should be able to get what you are after by using the 'Advanced Function' for your Sensor Temperature field. Select the option 'Null to Zero'. See screenshot below.


Forum image


Can you let us know if this option works for you?

Thank you,

Kyle



Hi Kyle,

This was specific case for which you have given us the solution.

But in many other cases my requirement is that in Normal reports the Option "Nulls as Zero" should be available and I want to make it "Off".Screenshot Attached here

Thus nulls should not appear as 0 in my Report or the corresponding charts as shown in screenshot.

Thanks,
Prateek Arora
Hi Kyle,

This was specific case for which you have given us the solution.

But in many other cases my requirement is that in Normal reports the Option "Nulls as Zero" should be available and I want to make it "Off".Screenshot Attached here.


Forum image


Thus nulls should not appear as 0 in my Report or the corresponding charts as shown in screenshot.

Thanks,
Prateek Arora

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.