Average of expression

[nareshthavidishetty]

Hi ,

How to calculate the average for the below expression.

Logic : num(Sum({$<A7AIDT = {"$(=vYesterday)"}>} ESIGN_COMPLETE_NEW)/Sum({$<A7AIDT = {"$(=vYesterday)"}>} TOTAL_ORDERS_DAILY_NEW),'##.00')*100)

Thanks...

[Jason_Michaelides]

I assume you mean you want to calculate the average of this expression over a given dimension? In that case try this:

Avg(

Aggr(

Sum({$<A7AIDT = {"$(=vYesterday)"}>} ESIGN_COMPLETE_NEW)/Sum({$<A7AIDT = {"$(=vYesterday)"}>} TOTAL_ORDERS_DAILY_NEW)

,<YourDimension>)

)

Hope this helps,

Jason

[Anil_Babu_Samineni]

Try with single quote. And usually average is

Sum(Sales)/Count(TOTAL Sales)

num(Sum({$<A7AIDT = {'$(=vYesterday)'}>} ESIGN_COMPLETE_NEW)/Sum({$<A7AIDT = {'$(=vYesterday)'}>} TOTAL_ORDERS_DAILY_NEW),'##.00')*100)

[nareshthavidishetty]

Hi,

It's showing the same percentage results.

Thanks..

[sunny_talwar]

Would you be able to share more details as to what you are looking to get?

[nareshthavidishetty]

Hi,

We have calculating the sales percentage based on the below,

Logic : num(Sum({$<A7AIDT = {"$(=vYesterday)"}>} ESIGN_COMPLETE_NEW)/Sum({$<A7AIDT = {"$(=vYesterday)"}>} TOTAL_ORDERS_DAILY_NEW),'##.00')*100)

We are getting the results as below,

But my user needs the average of these percentages(top of the bar),in an line chart as well..

Thanks..

[sunny_talwar]

Have you tried adding a Avg trendline?

[Jason_Michaelides]

Did you try my Aggr() solution?

[nareshthavidishetty]

yes, i have tried but it's showing an straight line.

I need to show an trend line.

[Jason_Michaelides]

Ah, then as Sunny T says, just add a trendline in the chart Expression tab.