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> |