Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am unable to handle NULL records in scripting.
For example Ename-WARD has the SAL and COMM in Q1 but no data in Q2.
When I select Q2 for WARD records showing '--'.
For SMITH COMM is 0 in Q1 and % is '--'.
Screen:
I want to show NULL values to zero in the script.So that I can see 0% in the report for Q2 as well.
Please help me.
Enclosed the app. for your reference.
Thanks in advance.
Hi,
Give 0% in Presentation tab-> Null and Missing Symbols option.
Regards,
Jagan.
Hi Folks, Any solution?
to handle the null values, u can use if conditions in expressions. Like,
% - If(isnull(Column(1)/Column(2)), 0, Column(1)/Column(2))
PFA
Hi ravic906 ,
Thank you for your solution. But % is not showing for 0 values. Could you advise?
Hi
if you want to show - null values to 0 in chart then there's an option in chart table properties.
Go to Properties-->presentation tab--> below you find null value symbol replace it with 0
hope it helps
Populate missing values
Hi i think u can use this
Hi,
Give 0% in Presentation tab-> Null and Missing Symbols option.
Regards,
Jagan.