Percentage of Policy issued expression

[Anonymous]

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

[#2]

post a sample file please

it'll be easier to check the expression

[Anonymous]

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