Hi
I am trying to show days of sales outstanding.
Year Month | No of Days |
| COGS R12 | Accounts receivable | DSO | I want to show this column, but how |
| 91 | 91 | 400 | 89 | 20,25 |
|
201303 | 91 | 0 | 100 | 50 | 54,73 | #DIV/0! |
201304 | 91 | 30 | 200 | 52 | -4,31 | 7,8 |
201305 | 91 | 61 | 300 | 87 | 44,09 | 17,69 |
201306 | 91 | 91 | 400 | 89 | -47,00 | 20,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