I am trying to modify a query in my sharepoint Designer, and I cannot figure out the porper syntax:
this is the original syntax:
<xsl:value-of select="format-number(sum(/dsQueryResponse/NewDataSet/Row/@XTNDPRCE), '$#,##0.00;-$#,##0.00')" />
The query is basically a sum of the field "XTNDPRCE". The field contains numbers of my invoices or return Items, unfotunately my negative amount still shows positive by design so I need to put a "-" sign in front of each return amount. In order to figure out which item is negative I need to do a calculation that implies another field: SOPTYPE.
This formula will change the sign accordingly. ((-(@SOPTYPE*2-7)*(@XTNDPRCE))
This what I tried to do:
<xsl:value-of select="format-number(sum(/dsQueryResponse/NewDataSet/Row/ ((-(@SOPTYPE*2-7)*(@XTNDPRCE))), '$#,##0.00;-$#,##0.00')" /> but that doesn't work
How can I include the formula in my sum syntax ?
Thanks in Advanced. let me know if you want me to describe better.