2 Replies Latest reply on May 9, 2017 8:52 AM by Eva K

    Calculate Avg of Sum of date difference

    Eva K

      I have a list of ids and their date, I want to show avg aging. It would be the date difference between the date field and Today(), summing that date diff value for all the ids and then averaging.

      I know I have to create an LOD, I created an LOd calculation in my workbook, but its not giving the correct result, can someone help?

      I have attached the .twbx file