set expression

[upaliwije]

I have following expression in my QV document and it is working fine

if(Sum({<DateType={PROVISION}>}PROV_AMOUNT)>0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO))

( This count should be positive value) eg100

I want combine the following expression to the above expression obtain one result

if(Sum({<DateType={PROVISION}>}PROV_AMOUNT)<0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO))

( This count should be negative  value) eg -25

Final result should be 100-25=75

Pls help me to build the expression

[sunny_talwar]

What id you do this:

=if(Sum({<DateType={PROVISION}>}PROV_AMOUNT)>0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO)) - if(Sum({<DateType={PROVISION}>}PROV_AMOUNT)<0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO))

[upaliwije]

It does not return the expected results but show - as value

[sunny_talwar]

If they work individually, I don't see why they won't work together in a single expression

[maxgro]

or maybe

rangesum(yourfirstexpr,  - yoursecondexpr)

[sunny_talwar]

Great idea

[upaliwije]

Can you please write the full expression

[upaliwije]

Pls see whether what I have written is correct

=if(rangeSum({<DateType={PROVISION}>}PROV_AMOUNT)>0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO)), -

{<DateType={PROVISION}>}PROV_AMOUNT)<0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO)

[sasiparupudi1 · Accepted solution]

rangesum(if(Sum({<DateType={PROVISION}>}PROV_AMOUNT)>0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO),0),-if(Sum({<DateType={PROVISION}>}PROV_AMOUNT)<0,count(DISTINCT{<DateType={PROVISION}>}CLAIM_NO),0))

[upaliwije]

Thanks all