0 Replies Latest reply: Aug 8, 2013 5:24 AM by Martin Toftebjerg RSS

    Accumulation divided by Accumulation in listbox shown by month

      Hi

       

      I am trying to show days of sales outstanding.

       

      Year MonthNo of Days
      COGS R12Accounts receivableDSOI want to show this column, but how

      91914008920,25
      2013039101005054,73#DIV/0!
      201304913020052-4,317,8
      20130591613008744,0917,69
      201306919140089-47,0020,2475

      =if((Date(Max(Date2)) - Date(Min(AxLiveStartDate))  +1) < 365, (Date(Max(Date2)) - Date(Min(AxLiveStartDate))  +1), 365)how do i get this.

      [Accounts receivable]/([COGS R12]/$(vWorkingCapital_KPI_NoOfDays))


      I have a start periode on a company, but i get 91 in all of them.

      This should be calculated with the accumulated values from cogs r12 and accounts receivable, but instead it uses the actual value.

       

       

      How do I calculate no of days and dso?

       

      Martin