2 Replies Latest reply: Aug 7, 2012 5:03 AM by Shubham Kumar RSS

    Percentage of Policy issued expression

    Shubham Kumar

      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