RE: How to add a conditional attribute for a sum

Posted by Ryan Puddephatt on
URL: https://discuss.orbeon.com/How-to-add-a-conditional-attribute-for-a-sum-tp32243p32248.html

Kannan
    Try if(sum(/path/to/number) gt 0) then format-number(sum(/path/to/number),'#.00') else ''
Ryan

Ryan Puddephatt
Software Engineer
 

Teleflex Group - IT UK
1 Michaelson Square
Livingston
West Lothian
Scotland
EH54 7DP
 
e> [hidden email]
t> +44(0)1506 407 110
f> +44(0)1506 407 108
w> www.teleflex.com

 


From: [hidden email] [mailto:[hidden email]]
Sent: 08 January 2007 07:34
To: [hidden email]
Subject: [ops-users] How to add a conditional attribute for a sum

Hi,
I have a repeat set where I have some amount and in the bottom I want to display the total amount. I have said something like,
<xf:output class="twms-total-value"
                 value="format-number(sum(/laborDetail/hoursSpent), '#.00')">
</xf:output>

However it is possible that some hours spent mite be empty, in which case I want to substitute 0 for empty while calculation. I tried something like,

format-number( sum(if(number(/taskView/claim/serviceInformation/serviceDetail/laborPerformed/laborDetail/hoursSpent), '#.00')

However this thing errors out saying that in a repeat row I should not use the number() function. Can someone tell me how this can be achieved?
--
Regards,
Kannan Ekanath


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws