4 Replies Latest reply on Mar 23, 2017 8:34 AM by Viresh Kolagimath

    Calculated field

    Viresh Kolagimath

      Hi Guys,

       

      I have data in the below format and i'm trying to use calculated filed to get the required result. But when i drag the calculated field it is not showing any data.

       

      type  freq       withdraw  bal

      a      daily       20           100

      b      weekly    30           70

       

      Calculated field = IF (type='a' and freq='daily' then (withdraw/bal) End

       

      The above expression is valid but not showing any data.

       

      thanks you for your support.

       

      Regards,

      Viresh