How to get SUM of "Price" base on selected "Item"

[mutanic]

Hi Bytes,

I'm trying to get SUM of column "Price" base on selected item in column "Item". I've got no idea how to solve this without have to use sort & group function through SPD. This has to be a basic summary at the bottom of main list. I try to use $nodeset instead of $Rows but it become error. This is how I try to create the code.

sum($Rows/@Price[@Unit='Item1'])

This code got no error but the output is "0".

sum($nodeset/@Price[@Unit='Item1'])

This code got error.

So how do I use the right code for this???

[jkmyoung]

3 choices: 1. Use node-set. 2. Use XSLT 1.1. 3. Don't use a variable.
Assuming you're using XSLT 1.0 and not 1.1, since you're getting this error.

1. You have to use a (non-standard) node-set extension function in order for this to work. Depending on your environment, it might be msxsl:node-set(), where
xmlns:msxsl="urn:schemas-microsoft-com:xslt" or xmlns:exsl:node-set() where exsl="http://exslt.org/common"