Sum() is returning 0 and i dont know why

[Daniel77]

Hi Experts,

I hope you can help me today.

I have a table with the Dimensions:

=If([Standard Name] = 'HIGG FEM',[Production Facility T1])

[Environmental Management Self]

In a table this is returning the expected values:

All i need is to convert this to a bar chart.

then i get the below message:

SO as normal i Sum the values:

Sum([Environmental Management Self])

Now i receive all 0 in the chart:

I have tried the following in the load:

Num(dim) as dim in the load

if is null(),'0', dim as dim

I just cannot get this to work and i have no idea why.

Can anyone give any assistance please?

Thank you

[hic · Accepted solution]

The numbers are left-aligned, meaning that they are not interpreted as numbers. They are texts.

You need to load this field (in the script) using
Num#([Environmental Management Self]) as [Environmental Management Self]

[Daniel77]

Thank you Hic,

I will give this a go and let you know the outcome, thanks

Daniel