strange data error

[#1]

Hi all,

I have a chart (pivot table) with the following data

Klant

Soort

Bedrag

However, I would like to make calculations with the amount in 'Bedrag', so I am using expressions to calculate the amount.

If I use this expression (

=

if(SOORT='RAMING', Sum(BEDRAG),0)

a lot of clients are disappearing. See picture, based on the same data, one with the formula above, one with the 'SOORT' as a dimension.

What am I doing wrong?

p.s. i made some data unreadable for privacy reasons.

[#2 · Accepted solution]

Hi, try this:

sum({$<SOORT = {'RAMING'}>} BEDRAG)

Regards

[#3]

thank you Ivan, that's it!!