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

[gsethuraman2]

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

[Taoufiq_Zarra]

Data source -> empty ? or '-' caracter

can you share a sample datta ?

[gsethuraman2]

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