I would like to multiply values from two columns and then display a sum of them in wingrid summary. Lets say its invoice summary, so its a summary of all prices multiplied by amount.
Forst idea was sum( [amount] * [price] ), which showed me #VALUE! error.
What I finally came up is:sum( product([amount],[price])) which according to my understanding should first multiply two values from one row and then generate sum of that. At least displays some values but i'm having problems figuring out where are they taken from, and why doesn't it work the way I would like to :)
Can anyone help me a bit?
Hi
You cannot do this with a single formula.
I've answered this question (or very similar ones) on the forums a number of times. Here are a few threads that should help you:
http://community.infragistics.com/forums/p/51602/269726.aspx#269726
http://community.infragistics.com/forums/p/38972/222478.aspx#222478