Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I want those entries who has booked and cancelled the policy no, with the same pass port number and same issuer name..
But i don't want those entries who has booked and cancelled with the same passport name...and booked it again..
For e.g
Pass port number: 707106899
Supriya Dutta should be considered not Susmita Goswami..
PFA
Hi,
Please try this:
=
if(
(
count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Booked"}>} [STATUS OF POLICY])
=
count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Cancelled"}>} [STATUS OF POLICY])
)
,
sum(Base)+sum(Tax)
)
Hi Mohammad,
What is Req_date here?
Because it is not changing with Issued by list box,so the both dates are for both Dutta & Goswami?
Thanks,
Neha
Hi,
Please try this:
=
if(
(
count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Booked"}>} [STATUS OF POLICY])
=
count(TOTAL <PASSPORT_NO,[Issued By]> {<[STATUS OF POLICY]={"Cancelled"}>} [STATUS OF POLICY])
)
,
sum(Base)+sum(Tax)
)
May be like in attached sample.
Expression :
=sum({<[Issued By]={"=Count({<[STATUS OF POLICY]={'BOOKED'}>}[STATUS OF POLICY])=1"}>
*
<[Issued By]={"=Count({<[STATUS OF POLICY]={'CANCELLED'}>}[STATUS OF POLICY])=1"}>
} Base)
+
sum( {<[Issued By]={"=Count({<[STATUS OF POLICY]={'BOOKED'}>}[STATUS OF POLICY])=1"}>
*
<[Issued By]={"=Count({<[STATUS OF POLICY]={'CANCELLED'}>}[STATUS OF POLICY])=1"}>
}Tax)
Thanks buddy..!!
Thanks for ur help..!!