2 Replies Latest reply on Jan 14, 2019 10:45 AM by Alysse Mea

    Subtract assigned value to each month

    Alysse Mea

      Help please! I have this view below. I need to subtract a value from each month. So my Nov 2018 is fixed at 120,000,000,000. Then Dec 2018 is 120,000,000,000 - 22,559,948,212=97,440,051,788. Jan 2019 is 97,440,051,788-14,034470 and so on. I was thinking this is a lookup function but can't figure it out. I attached my 10.5 workbook. Thank you!

       

      I need my final view to look like this: