Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is wrong in this formula? I couldnt get the average
RangeAvg(Above(sum([$(vCurrency) Satış]) / (sum([KG Satış]))*1000,0, 12))
Hi guys,
I forgot uncheck the accumulate option, thats why i couldnt get the average.
Thanks for replies.
Can you share a sample app to look into? And what is Satis here, is that a field name ?
What are you getting and what do you expect to get?
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
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
I tried but it doesnt work.
I couldnt provide a sample bc its a company document, all .qvw's are classified info
Have you checked this link:
Preparing examples for Upload - Reduction and Data Scrambling
Hi guys,
I forgot uncheck the accumulate option, thats why i couldnt get the average.
Thanks for replies.