cancel
Showing results for 
Search instead for 
Did you mean: 

Local Calculation (Summation) in query doesn't display correctly in web

Former Member
0 Kudos

Hi All,

I have been working on a complicated query where I have formulas that perform calculations. I then Hide these formulas and use them in another formula for further calculations. The new calculations I then use local summation to basically just add the columns values and come up with an overall result. Works perfect and is displayed perfectly.

Problem is now in the web. Either using a Pie Chart or just simply an Analysis item, the values are not displayed correctly at all. The Pie Chart only displays the first row of data (not the overall result...which is a local summation...which is what I would prefer) and suprised that the Analysis item doesn't basically display what the query does. I'm guessing it has to do with this local calculation.

Can someone explain this behavior?

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Anyone any ideas?