problem with getting proper results from complex formula

[Edyta]

Hi guys,

I need to calculate the rate for each client to show it on bar chart. My formula is as below:

=If([Load]='TTL', [Avg weight]*1000*(100-[Lost items %])/([weighted mean]*[FCR])/10)

Qlik shows the correctness of formula, but no results are shown on bar chart.

All names in formula are taken from data.

what is wrong with the above formula?

[sunny_talwar · Accepted solution]

Where exactly are you using this expression? I mean what kind of object? May be you need to add a Sum() or some kind of aggregation somewhere

=Sum(
If([Load]='TTL', [Avg weight]*1000*(100-[Lost items %])/([weighted mean]*[FCR])/10)
)

[Edyta]

Could you explain whatthe sum does in this example?

[sunny_talwar]

If there are multiple values per dimension/s... it adds up the value before displaying the output....