Unable to get the exact results for sumifs formula (which is used in excel) using qlikview

[srinivas1921]

Hi ,

Please help on write below excel formula in qlikview to get exact results.

[Vegar]

For the first calculation use

Sum({<Level=-{1}>}[Sales MTD])

For the second use

Sum({<Level={1}>}[Sales MTD])