How to convert null(-) values into 0 in straight table

[#1]

Hi all,

i have small confusion in straight table.

how to convert null(-) value into 0 means

in my straight table my data has

a            b

---         -----

-           10

10           -

-            -

my straight table showing above table.

i want show my straight table below how. please share me

a               b

---             ---

0             10

10             0

0              0

i want show my straight second one .

[Anonymous]

Hi subbareddy,

On property objects, on presentation tab, uncheck Suppress zero-values, and Null Symbol and Missing Simbol may be 0 too.

Kind regards.

[tamilarasu]

Hi,

Go to Presentation Tab and write 0 instead of '-'  in Null symbol box.

[maleksafa]

easiest way would be to go to the presentation tab and at the bottom set the null symbol to 0, other options would be to use the isnull() function in the expression and covert the values to 0. same thing can be applied in the reload script.

[bindu_apte]

Hi,

Please find the settings where you can change the null symbol '-' to '0'

[beck_bakytbek]

Hi subba,

i had such Problem in the case with TableBox, i am not sure, but you can try to do tha same way in case with straight table.

my way of proceeding does look like:

first step: in Script-Area;

NullAsValue*;

Set NullValue ='';

Load

if(len(trim([yourField]))= 0, 'yourSign', [yourField]) as YourName

Resident YourName;

i hope that helps

beck

[nicolas66]

Bonjour,

try Alt(a,0).

Bonne journée,

Philippe

[pho3nix90]

If you want to accomplish this model wide, then in script add the following under the environmental variables (default vars)

NullAsValue *;

Set NullValue = 0;

if you want to only do this per chart use the example Tamil gave you,

Alternatively, you could also do the below.

if(isNull(), 0, )

[susovan]

Try this,