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
Hi,
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
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
| Free forum by Nabble | Edit this page |