1 Reply Latest reply: Mar 28, 2017 11:46 AM by Sunny Talwar RSS

    How to spread an invoice value over a number of months.

    Joseph Eftamandilos

      I have set up a calendar with min day Today() and max day the max expected invoice data of a sale. I want to show the full value of that invoice spread over the number of months or quarters between today and that date which will be different for every invoice. So to see an average value coming in each month from that invoice. Ideally I would like to show this on a pivot table with month and quarter and year at the top.