3 Replies Latest reply: Mar 27, 2018 12:16 AM by Prashant Sangle RSS

    KPI is not same as totals in table

    Krithika Rees

       

      The expression I used to calculate 0 days is

      =sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0  , [Debit/Credit Amount],0))

      when I use the same expression in KPI it gives me a different total.

       

      any help would be appreciated!