Below tutorial shows how to use Formulas in XSLT
Step1 : Insert DataView Web Part. Select the List you wanted to show it in XSLT
and Click on Show Data
Step 2: Select the Columns would like to display and click on Insert Selected
Fields as -> Multiple Item View [This will query all the Records] -> Single Item
View [Query only one Single Record]
Step 3: It will display the below columns. Click on DataView Properties
Step4: Select Show View footer
Step5: Count(/dsQuery/Response/Rows/Row) – This will give the no of records
sum(/dsQuery/Response/Rows/Row/<@ColumnName>) – This will do the summation of
all the values on columnName . Likewise the following operators can be used in
XSLT (average(), ceiling(), floor(), max(), min(), number(), random(), etc..)
| Count : <xsl:value-of select="count(/dsQueryResponse/Rows/Row)" /> <br /> Collateral : <xsl:value-of select="sum(/dsQueryResponse/Rows/Row/@Collateral)" /> <br /> Web Designing : <xsl:value-of select="sum(/dsQueryResponse/Rows/Row/@Web_x0020_Designing)" /> |
