topic Average and Set Analysis Expression in App Development

Average and Set Analysis Expression

ZoeM — Sat, 16 Nov 2024 06:50:11 GMT

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.

Re: Average and Set Analysis Expression

sunny_talwar — Wed, 16 Jan 2019 20:52:46 GMT

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])

Re: Average and Set Analysis Expression

Somasundaram — Wed, 16 Jan 2019 20:54:11 GMT

May be like this,

=Count({$<[#of Days After Invoice]={">14"},[Date Type]={'VPP Dates'},[Reference_Only]-={'Yes'}>}[Sales])

Re: Average and Set Analysis Expression

ZoeM — Wed, 16 Jan 2019 21:02:45 GMT

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)?