7 Replies Latest reply: Aug 9, 2016 2:33 AM by Buse Türkoğlu

RangeAvg is not working

What is wrong in this formula? I couldnt get the average

RangeAvg(Above(sum([\$(vCurrency) Satış]) / (sum([KG Satış]))*1000,0, 12))

• Re: RangeAvg is not working

Can you share a sample app to look into? And what is Satis here, is that a field name ?

• Re: RangeAvg is not working

What are you getting and what do you expect to get?

• Re: RangeAvg is not working

Hi,

Green numbers must be same with the green bar chart.

And gray number must be same as gray bar chart.

Formula for bar chart is; RangeAvg(Above(sum([\$(vCurrency) Satış]) / (sum([KG Satış]))*1000,0, 12))

Formula for table is; rangesum( before( sum([\$(vCurrency) Satış]),0,NoOfColumns(TOTAL) ) ) / rangesum( before( sum([KG Satış]),0,NoOfColumns(TOTAL) ) )/1000

Nisan                       Mayıs                                 Haziran

• Re: RangeAvg is not working

The formula are not exact match of each other. There are a lot of differences between the two formulas. I can propose something, but not 100% certain it will work... try this in the bar chart

RangeSum(Above(Sum([\$(vCurrency) Satış]), 0, NoOfRows(TOTAL)))/RangeSum(Above(Sum([KG Satış]), 0, NoOfRows(TOTAL)))/1000

or

RangeSum(Above(Sum([\$(vCurrency) Satış]), 0, RowNo(TOTAL)))/RangeSum(Above(Sum([KG Satış]), 0, RowNo(TOTAL)))/1000

If they do not work, would you be able to provide a sample to look at what is going on?

Best,

Sunny

• Re: RangeAvg is not working

Hi guys,

I forgot uncheck the accumulate option, thats why i couldnt get the average.

Thanks for replies.