Forum Discussion
ljx0648
Helper III
Helper IIIAdding Average Sales for Current Fiscal Year as a Line in Line Chart
Dear Community Members, I am trying to implement a average sales line (ONLY for current year) inside a daily sales line chart. Line Chart: X Axis: Date Dimension Y Axis: Sum of Sales ...
ljx0648 , Please check if the attached file can help. I added three measures and date table
amitchandak
Super User
Super Userljx0648 , Please check if the attached file can help. I added three measures and date table
ljx0648Helper III
Helper IIIThank you for your prompt response!
The number is really close to what is needed, however, the number calculated in the file provided is slightly off with the number I calculated
- $330320/70 = $4719
I tried to modify the ENDOFYEAR date in Avg till year end 1 formula to "10/31“ （as new fiscal starts on Nov 1） but it did not align with the calculation as well.
May I know if there is any modification can be made to get the numbers as I did?