This content has been marked as final. Show 2 replies
I need a single expression, in a straight chart where percentage of policy issued within 7 days should be shown. I am writing expression like :
if(Business_Source_Name='A' or Business_Source_Name='B' or Business_Source_Name='C' or Business_Source_Name='D') and (NB_Dt_Terms_Sent_Client)-(NB_Inquiry_Received_Date)<=7, if(not isnull(DATE_POL_ISSUED) and not isnull(NB_Date_Closing_Recd),1) but not getting correct result. These are the exact field is there is DB, please give me the expression where I can achieve this within 7 days and within 10 days like wise.