topic Re: From Query receiving Null for some fields how to display that as 0.00 currently its displayed as in App Development

From Query receiving Null for some fields how to display that as 0.00 currently its displayed as '-'

gsethuraman2 — Fri, 31 Jan 2020 15:29:31 GMT

From Query receiving Null for some fields how to display that as 0.00 currently its displayed as '-'

How to edit data in the script to display it as 0.00 when there is no data in the table .. currently getting Null from the query data which its displaying as "-" in the output

Re: From Query receiving Null for some fields how to display that as 0.00 currently its displayed as

Taoufiq_Zarra — Fri, 31 Jan 2020 17:00:42 GMT

Data source -> empty ? or '-' caracter

can you share a sample datta ?

Re: From Query receiving Null for some fields how to display that as 0.00 currently its displayed as

gsethuraman2 — Fri, 31 Jan 2020 20:21:04 GMT

Hi taoufiq,

When i receive the data from the query as NULL which is due to left join then output dispalying as - in the output

if i receive 0.00 then i receive the output as 0.00 this is fine ..

But when i receive Null From the query data there is the issue

Re: From Query receiving Null for some fields how to display that as 0.00 currently its displayed as

gsethuraman2 — Fri, 31 Jan 2020 20:25:43 GMT