Forum Discussion

sandee's avatar
sandee
Helper I
6 years ago

Calculate with Sum Function

Hi All,   I am trying to apply the formula to get "total Amt Due" for customer based on the "No of Days above then 0", but i am doing drag and drop it is not working, please can you guide where i a...
sandee's avatar
sandee
Helper I
6 years ago

Greg, you are right i should have provided more information for this , sorry for this.

 

below is an example table : i am applying to get "Total Amount" which is above then "0" Dys from "Debt Overdue Days" on client basis.

 

 

i hope i am clear this time. thanks in advance

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

sandee Still not quite clear. So, if that is the source data, what is the expected output?

  • sandee's avatar
    sandee
    Helper I
    6 years ago

    I am looking for client name where the "Total amount" is greater than "0" No of days,

     

    please ignore "cust No"

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      6 years ago

      sandee So:

      Total Amount = SUMX(FILTER('Table',[Days overdue]>0),[Amt Due])

      ? 

      • sandee's avatar
        sandee
        Helper I
        6 years ago

        It is not working .