Forum Discussion
Average Days to Pay by Customer
Hello Everyone, I am trying to figure out which percentage of customers we have that PAY within a given period (1-30, 31-60, 61-90, 91-121,121+). Since there's several work orders, I am taking t...
Ashish_Mathur
Super User
Super UserPaste the raw data in a format that can be pasted in an MS Excel file. No private message.
some my dates are showing in -Minus thast why its not showing It comes between 31-60 .
becoz the customer not paid yet and the value is o .how can I remove the minus so it will give me the days it comes in. for eg there is one overdue -43 .it should comes between 31-60. it showing no due .because I passed the condtion showing below