wrong totals pivot table

[Simon4]

hi all,

I am making a table with WIP netto sales price, but the totals in my pivot table don't add up.

how can i overcome this?

should be €14.249.879,14 but instead it is showing the total netto sales price, not the wip total netto sales price

[Or]

Since you didn't include your expression or the underlying data, there's no way to tell what the problem is...

[Simon4]

the expression:

MONEY(
IF(
DATEINWIP < vpeildatum
AND
DATEOUTWIP> vpeildatum
OR
ISNULL(DATEOUTWIP)
, Sum(NETSALESAMOUNT), 0)
,'€#.##0,00', MoneyThousandSep)

the expressions sums the salesprice of all the work in progress. when i unfold the tables and total them in excel they count up to the right total: 14 million, just like in the left table. But qlik shows the total of ALL salesprices. not filtering out the wip.

[Simon4]

vpeildatum is a variable for a date that can be chosen with a datepicker

[Or · Accepted solution]

For starters, I'd suggest you try moving the if() statement inside the Sum() statement rather than vice versa. That's the most likely issue (again, without the underlying data, it's hard to tell more).