How to increment a count and do sum of all data using xslt

Increment a Counter:
?
<!-- Total Bill and Not Bill Payment Count Start -->
<xsl:variable name="totalEventCount"> 
       <xsl:for-each select="/AlertMessage/message/body/weeklyExpenseSumaryReport/projectedTransactionViews/projectedTransactionView">
<xsl:variable name="transactionBaseType" select="transactionBaseType/text()" />
   <cost>
        <xsl:value-of select="123"/>
              </cost>
</xsl:for-each>
  </xsl:variable>

<xsl:variable name="totalEventData">
    <xsl:value-of select="count(exsl:node-set($totalEventCount)/cost)"/>
</xsl:variable>


Summation of a data:
?
<!-- Total  Bill Payment sum Start -->
<xsl:variable name="totalSumOfNotCredit"> 
       <xsl:for-each select="/AlertMessage/message/body/weeklyExpenseSumaryReport/projectedTransactionViews/projectedTransactionView">
<xsl:variable name="transactionBaseType" select="transactionBaseType/text()" />
<xsl:variable name="yMoneyAmount" select="yMoney/amount/text()" />
<xsl:variable name="yMoneyCurrencyCode" select="yMoney/currencyCode/text()" />
<xsl:if test="$transactionBaseType!=$cr">
   <cost>
        <xsl:value-of select="$yMoneyAmount"/>
              </cost>
              </xsl:if>
</xsl:for-each>
  </xsl:variable>

<xsl:variable name="totalSumOfNotCreditData">
    <xsl:value-of select="sum(exsl:node-set($totalSumOfNotCredit)/cost)"/>
</xsl:variable>

<!-- Total  Bill Payment sum End -->
Summation of a data:
?
<AlertMessage>

<message>
<body>
<weeklyExpenseSumaryReport>
<projectedTransactionViews>
<projectedTransactionView>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
<siteName>DagBank</siteName>
</transactionAcountView>
<yMoney>
<amount>1000</amount>
<currencyCode>USD</currencyCode>
</yMoney>
<categorizationKeyword>iMusic Education</categorizationKeyword>
<transactionCategory>
<categoryId>6</categoryId>
<categoryName>Education</categoryName>
<categoryTypeId>3</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</transactionCategory>
<postDate>12-05-2017</postDate>
<currentDate>05-05-2017</currentDate>
<transactionBaseType>credit</transactionBaseType>
<dayLeft>2 Days</dayLeft>
</projectedTransactionView>
<projectedTransactionView>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
<siteName>DagBank</siteName>
</transactionAcountView>
<yMoney>
<amount>1000</amount>
<currencyCode>USD</currencyCode>
</yMoney>
<categorizationKeyword>Global Charitable</categorizationKeyword>
<transactionCategory>
<categoryId>3</categoryId>
<categoryName>Charitable Giving</categoryName>
<categoryTypeId>3</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</transactionCategory>
<postDate>12-05-2017</postDate>
<currentDate>05-05-2017</currentDate>
<transactionBaseType>credit</transactionBaseType>
<dayLeft>2 Days</dayLeft>
</projectedTransactionView>
<projectedTransactionView>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
<siteName>DagBank</siteName>
</transactionAcountView>
<yMoney>
<amount>1000</amount>
<currencyCode>USD</currencyCode>
</yMoney>
<categorizationKeyword>Global Reg. Salary</categorizationKeyword>
<transactionCategory>
<categoryId>75</categoryId>
<categoryName>Salary</categoryName>
<categoryTypeId>3</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</transactionCategory>
<postDate>12-05-2017</postDate>
<currentDate>05-05-2017</currentDate>
<transactionBaseType>credit</transactionBaseType>
<dayLeft>2 Days</dayLeft>
</projectedTransactionView>
<totalInflow>
<totalInflowSign>+</totalInflowSign>
<totalInflowAmount>20000</totalInflowAmount>
<currencyCode>USD</currencyCode>
</totalInflow>
<totalOutflow>
<totalOutflowSign>-</totalOutflowSign>
<totalOutflowAmount>1500</totalOutflowAmount>
<currencyCode>USD</currencyCode>
</totalOutflow>
<totalEvent>6</totalEvent>
<toatlBillPayEvent>5</toatlBillPayEvent>
<fromDate>08-05-2017</fromDate>
<toDate>13-05-2017</toDate>
</projectedTransactionViews>
<itemSummaryResponse>

</itemSummaryResponse>
<expenseTransactions>
<expenseTransaction>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
</transactionAcountView>
<facadeAmount>
<amount>999.999</amount>
<currencyCode>USD</currencyCode>
</facadeAmount>
<transactionBaseType>credit</transactionBaseType>
<facadeTransactionCategory>
<categoryId>27</categoryId>
<categoryName>Deposite</categoryName>
<categoryTypeId>2</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</facadeTransactionCategory>
<txnDisplayDate>04-05-2017</txnDisplayDate>
</expenseTransaction>
<expenseTransaction>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
</transactionAcountView>
<facadeAmount>
<amount>6.36</amount>
<currencyCode>USD</currencyCode>
</facadeAmount>
<transactionBaseType>credit</transactionBaseType>
<facadeTransactionCategory>
<categoryId>96</categoryId>
<categoryName>Interest Income</categoryName>
<categoryTypeId>2</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</facadeTransactionCategory>
<txnDisplayDate>04-05-2017</txnDisplayDate>
</expenseTransaction>
<expenseTransaction>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
</transactionAcountView>
<facadeAmount>
<amount>250.0</amount>
<currencyCode>USD</currencyCode>
</facadeAmount>
<transactionBaseType>credit</transactionBaseType>
<facadeTransactionCategory>
<categoryId>14</categoryId>
<categoryName>Insurance</categoryName>
<categoryTypeId>3</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</facadeTransactionCategory>
<txnDisplayDate>04-05-2017</txnDisplayDate>
</expenseTransaction>
<expenseTransaction>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
</transactionAcountView>
<facadeAmount>
<amount>59.99</amount>
<currencyCode>USD</currencyCode>
</facadeAmount>
<transactionBaseType>credit</transactionBaseType>
<facadeTransactionCategory>
<categoryId>1</categoryId>
<categoryName>Uncategorized</categoryName>
<categoryTypeId>1</categoryTypeId>
<categoryLevelId></categoryLevelId>
</facadeTransactionCategory>
<txnDisplayDate>04-05-2017</txnDisplayDate>
</expenseTransaction>
<expenseTransaction>
<transactionAcountView>
<accountName>ACC-SC1</accountName>
<accountNickName>Kartik</accountNickName>
<accountNumber>xxxx1234</accountNumber>
</transactionAcountView>
<facadeAmount>
<amount>100.999</amount>
<currencyCode>USD</currencyCode>
</facadeAmount>
<transactionBaseType>credit</transactionBaseType>
<facadeTransactionCategory>
<categoryId>11</categoryId>
<categoryName>Healthcare/Medical</categoryName>
<categoryTypeId>3</categoryTypeId>
<categoryLevelId>3</categoryLevelId>
</facadeTransactionCategory>
<txnDisplayDate>04-05-2017</txnDisplayDate>
</expenseTransaction>
</expenseTransactions>
</weeklyExpenseSumaryReport>
</body>
</message>
</AlertMessage>

Previous
Next Post »