NULL as Zero option not in Normal Tab
8 September, 2015
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:
Option is Available in Cross tab:
Normal Report:
No null as Zero option in Normal Tab:
Kindly let us know if we are missing any option to get the same.
Thanks & Regards,
Prateek
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:
Option is Available in Cross tab:
Normal Report:
No null as Zero option in Normal Tab:
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.
Can you let us know if this option works for you?
Thank you,
Kyle
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.
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
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.
Thus nulls should not appear as 0 in my Report or the corresponding charts as shown in screenshot.
Thanks,
Prateek Arora
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