1 Reply Latest reply on Jan 15, 2019 9:30 PM by Chris McClellan

    Calculate only positive and  negative delta's

    Geert van der Weide

      Dear all,

       

      I have a problem i am wondering if it can be solved: a client wants to see a table where he accumulates only the positive delta's: he has the following schema:

       

      The balances are the current balances on the end of the month, accumulated across multiple clients. The data-set contains the balances per day per client. We want to calculate the positive and negative delta's:

      only show the amount that has increased and the amount that has decreased.

       

      Can this be done?

       

      Kind regards.