1 Reply Latest reply on Oct 5, 2018 5:16 PM by Daniel Lawrence

    Sales by day dynamically adjusted by time period

    Daniel Lawrence

      Hi All,

       

        I tried searching for this already as I assumed it was a common question but did not find it.  I am looking to do sales(or revenue) by day that dynamically adjusts as you cycle through the date from day, week, ..., year.

      It just needs to be sum(sales)/(# of days in period) but data types do not work for sales/count(date).  At first I thought about LODs, but nothing is being fixed as both the total sales and the number days is changing.  Has anyone found a solution for this seemingly easy problem?