Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community.
I have an issue with incorporating the Average calculation within set analysis.
I have a Dimension called # of Days After Invoice and I need to calculate the average days > 14 days. In the below expression, I am counting the number of sales I have that meet the requirement:
=Count({$<[#of Days After Invoice]={'>14'},Sales,[Date Type]={'VPP Dates'},[Reference_Only]=-{'Yes'}>}[Sales])
I want to create a KPI in a text box that shows the average number of days and I cannot for the life of me figure out how to show this.
Any help rendered is truly appreciated.
Not really clear what you have, but may be try this
=Avg({$<[#of Days After Invoice] = {'>14'},Sales,[Date Type] = {'VPP Dates'}, [Reference_Only]=-{'Yes'}>} [#of Days After Invoice])
That did not work Sunny, somehow I am getting a larger number than I would in Excel when I export the data file. Do I have to aggregate it (aggr)?