Amount ?

[#1]

Hi All,

I have to write the Expression in qlikview for this:

(Sum(AP amount) + Sum(BP amount) + Sum(CP amount))

/

Sum(DP amount)

Regards,

Helen

[nizamsha]

what u written is correct ,but when the year is on selection it show the value for current year only so make sure what u  want .

[Anonymous]

If the field names have spaces in them you will need to use square brackets: e.g Sum( [AP Amount] )

[its_anandrjs]

Elaborate more about the expression if in the expression if it is fields then you have to use

(Sum([AP amount]) + Sum([BP amount]) + Sum([CP amount]))

/

Sum([DP amount])

or if AP,BP,CP,DP are conditions then you have to use SET analysis.

[#5]

Sum([AP amount] + [BP amount] + [CP amount])

/

Sum([DP amount])

Alternatively, the commutative property should give you the above expression.