How i can add dummy Zero against some fields

[sarfaraz_sheikh]

Dear All,

Any idea how i can add dummy zeroes against particular fields in order to show them in table.

Any trick regards the same help would be much appreciated.

Sarfaraz

[kaushiknsolanki]

Hi,

What kind of data you have in that field.

If the values are null, you can use the if statement along with isnull(), something like below.

If(Isull(Field),0,Field)

To make null values as 0.

Regards,

Kaushik Solanki

[#3]

Can you elaborate with sample examples what you want to get as output

[krishna20]

Hi,

Goto presentation tab in the chart properties.At the bottom there is an option like Null symbol and missing symbol.There you can place '0'.

Hope it helps.

[gautik92]

in script jus add if(isnull(Field),'0',field)

[ashfaq_haseeb]

Hi,

It depends on your requirement, if you just want to append zero before field then use below approach

Load

Field1,

0&Field1 as CustomField,

Field2

from table;

Regards

ASHFAQ

[saimahasan]

Hi Sarfaraz,

If your query is resolved then please close it.