Check for positive and negative about in a XSL StyleSheet

abooysen2 used Ask the Experts™

on 2011-05-17

Hi

I have a xml that I am Transforming but one element is an amount field that contains positive's and negatives. I want to know how can I check for positive's and negatives in a XSL StyleSheet

here is my xml
<?xml version="1.0" encoding="utf-8"?><transferupload><transfer><Currency>USD</Currency><LegalEntity>xxxx</LegalEntity><Accountid>1020</Accountid><Movement>-111390.73</Movement><ValueDate>2011-05-16</ValueDate><Narration>CFC Transaction 1300192643504</Narration><Counterparty>xx TREASURY</Counterparty></transfer></transferupload>

<?xml version="1.0" encoding="utf-8"?><transferupload><transfer><Currency>USD</Currency><LegalEntity>XXX</LegalEntity><Accountid>1020</Accountid><Movement>111390.73</Movement><ValueDate>2011-05-16</ValueDate><Narration>CFC Transaction 1300192643504</Narration><Counterparty>XXXXX TREASURY</Counterparty></transfer></transferupload>

Here is my XSL StyleSheet to get my Movement element
                                    <calypso:principal>
                                          <xsl:value-of select="transferupload/transfer/Movement"/>
                                    </calypso:principal>

Now I can to check in element quantity for positive amounts and negatives abouts
                  <calypso:quantity>
                              <xsl:value-of select="if (@Movement < ) then '-1.0'
                                    else '1.0'"/>
                        </calypso:quantity>

View Solution Only

Gertone (Geert Bormans)Information Architect

Verified Expert

Top Expert 2006

Commented: 2011-05-17

yes, you can simply check

<xsl:if test="@Movement &lt; 0">
   <xsl:text>-1.0</xsl:text>
</xsl:if>

Open in new window

or use choose

<xsl:choose>
 <xsl:when test="@Movement &lt; 0">
   <xsl:text>-1.0</xsl:text> 
 </xsl:when>
 <xsl:otherwise>
   <xsl:text>1.0</xsl:text>
 </xsl:otherwise>
</xsl:choose>

this works in XSLT2.0 only

<xsl:value-of select="if (@Movement < 0 ) then '-1.0' else '1.0'"/>

abooysen2

Author

so

<xsl:if test="@Movement < 0">
<xsl:text>-1.0</xsl:text>
</xsl:if>

means if I have a positive amount it will be 1.0
and
means if I have a negative amount it will be -1.0

no, it just sets the output entry to -1.0 if @Movement is smaller than 0
if you need what you just subscribe, you will need the choose construct

i used <xsl:value-of select="if (@Movement < 0 ) then '-1.0' else '1.0'"/> and it worked 100% thanks

so you are using XSLT2, good to know
cheers

Check for positive and negative about in a XSL StyleSheet

Premium Content

Premium Content

Explore our Suite of Services