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?