Error in Expression

[upaliwije]

Dear Friends

The following expression does not work

if(RENEWABLE>0,count(DISTINCT {<EDATE={"=$(vFdate)"}>}POLICY_NO))

Pls help me to correct it

[ecolomer]

But do you have a mistake Or does not give the results...

[ecolomer]

Check the date formats. Usually this is a common problem.

[Kushal_Chawda]

try this

if(RENEWABLE>0,count(DISTINCT {<EDATE={"$(=vFdate)"}>}POLICY_NO))

[vinieme12]

Maybe

count(DISTINCT {<EDATE={"$(vFdate)"}>}  if(RENEWABLE>0,POLICY_NO))

or

count(DISTINCT {<EDATE={"$(=vFdate)"}>}  if(RENEWABLE>0,POLICY_NO))

or

count(DISTINCT {<EDATE={"$(vFdate)"}, POLICY_NO={"=RENEWABLE>0"}  >}  POLICY_NO)

[sunny_talwar · Accepted solution]

Or this

Count(DISTINCT {<EDATE={"$(vFdate)"}, RENEWABLE = {'>0'}>} POLICY_NO)

or with equal sign

Count(DISTINCT {<EDATE={"$(=vFdate)"}, RENEWABLE = {'>0'}>} POLICY_NO)

[#7]

May be

count({<RENEWABLE={'>0'}, EDATE={$(vFdate)}>} Distinct policy_no)