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.