Forum Discussion

kattlees's avatar
kattlees
Icon for Post Patron rankPost Patron
8 years ago

Cumulative sum with VALUES filter issue?

I have a deduction table.... I'm trying to get a projected total of the deduction value for the year up to 5000. Once it hits 5000 it should stop.   So I have the following: A column: DedValue=if...
Need Help
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

What are your formulas for PayDatesDone and TotalPayDates?

  • kattlees's avatar
    kattlees
    Icon for Post Patron rankPost Patron
    8 years ago

    In Pay Dates Table

     

    PayDatesDone=sum(PayDates[CountPayDates])

    CountPayDates=if(PayDates[PayDate]<today(),1,0)

     

    PayDatesLeft is a value we enter manually

     

    TotalPayDates = PayDatesDone+PayDatesLeft