Wrong Total

[Mayur_Bisht]

Hi, I am new to qliksense.

For simple IF statement, Total is showing wrong although the individual line items are populating correctly.

Here is the exp

If([credit field]='credit',

Sum([crate]*[percent]*[quantity]),

Sum([drate])*[percent]*[quantity]))

Credit field has credit and debit

Thanks

[Tanalex]

You have one too many ) at the end.  This should work:

If([credit field]='credit',

SUM ([crate]*[percent]*[quantity]),

SUM ([drate])*[percent]*[quantity])

[Vegar]

Are you using this in an table? The default total in a table is expression total which could be different to the sum of all rows. Try changing your total aggregation to sum of row  to see if that gives you the expected output.