Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
It does not return the expected results but show - as value
If they work individually, I don't see why they won't work together in a single expression
or maybe
rangesum(yourfirstexpr, - yoursecondexpr)
Great idea
Can you please write the full expression
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)
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))
Thanks all