8 Replies Latest reply: Jul 17, 2017 9:12 AM by Gareth Lloyd RSS

    Expression Help

    Gareth Lloyd

      Good morning,

      I require some help if possible please.

      I have an expression that counts the number of invoices overdue for suppliers - count({<[Days Overdue]={'>0'}>}[$(=CName)])

       

      I am now trying to find the average number of days these invoices are overdue by.

      I have tried avg({<[Due Date]-[Payment Date]={'>0'}>) but I get some crazy results returning, even for suppliers that have no invoices overdue!

      Any ideas guys?

      Thanks in advance!