Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
In my Application Showing null values like , whenever i select
-> Go to Chart Properties -> Select Dimension ->I Select Suppress where value is Null
when i select this the count of values showing wrong and select show all values the count of all values showing exact values, but in dimension showing Null Symbol how do i remove this null symbol?
see the attached files below mentioned.
Can anybody give me solution for this Null Values
waiting for reply
Regards,
Khasim.
PFA SOULTION
VIKAS
Dear Khasimvali85,
Here it is,
Alt(Field_Name, '-', 0) as FieldName
Kind regards,
Ishfaque Ahmed
Hi Vikas,
Thanks For revert but i don't need another column in dimension'NOT AVAILABLE'.
Regards,
Khasim.
Hi Khasim,
In order to suppress the null value, you need to tick "Suppress When Value is Null" in Dimensions Tab but the sum of PendingCallCount will show 17925 instead of 18103 in Subtotals row because you have some records where PendingCallCount has values without OrganizationBrand. Hope this explains.
Regards,
Sajeevan
If you absolutely have to just supress the null but keep the total as the overall value, you could use dimensionality to sort this for you (I would recommend fixing the nulls though)
see attached
hope that helps
Joe
hi Sajeevan,
Thanks for revert my calls count is 18103 for today from database also i have checked calls count.
when i am using chart objects i am getting null symbol. why i am getting this is there any reason?
Regards,
Khasim.
Hi SImmons,
Thanks for this help its great.
Regards,
Khasim.
Hi Khasim,
The reason was explained in my earlier reply. You have some records where PendingCallCount field has values but the OrganizationBrand field is empty (i.e. Null). You can check this by adding a Table box with these variables.
Regards,
Sajeevan
Hi Sajeevan,
As you Said my Organization Brand field is not empty. i already checked, may be the problem is data showing null.
Regards,
Khasim.
Hi Khasim,
You have 59593 rows of data in your table "AllIndiaReport".
Find below some stats I have produced out of your data to prove that the OrganizationBrand field is empty when PendingCallCount=1.
OrganizationBrand | Total Count | PendingCallCount=1 |
AC | 1392 | 375 |
CLR | 699 | 207 |
Focus India | 14251 | 4170 |
Greather India SAN+KEL | 11916 | 3411 |
Greather India VIDEOCON | 22808 | 7778 |
KENSTAR | 6182 | 1672 |
OTHER | 1676 | 312 |
Non-Empty OrganizationBrand | 58924 | 17925 |
Total Rows | 59593 | 18103 |
Empty OrganizationBrand | -669 | -178 |
Thanks,
Sajeevan