Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Best Regards,
Skumar
post a sample file please
it'll be easier to check the expression
Hi Pari,
Actually I have to show policy issued within 7 days and 10 days. show can you tell me how I can calculate that. I have two date fields term sent date and policy issue date. any specific function need to apply. I have to show in a straigt chart.
best regards,
Skumar