add "not(empty(/path/to/number)) and" to the if

 

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> <a href="http://www.teleflex.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">www.teleflex.com

 

---

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

Ryan,
The suggestion of if(sum(/path/to/number) gt 0) then format-number(sum(/path/to/number),'#.00') doesnt work for me because the sum(/path/to/number) itself throws an error because the value is an empty "". The following error is thrown in the browser (If I use tools like firebug etc in firefox)

<message>oxf:/ops/xforms/xforms-server.xpl, line 44, column 44, description executing processor: oxf:/ops/xforms/xforms-server.xpl, line 38, column 95, description reading processor output: null, line -1, column -1: Cannot convert string "" to a double


Cannot convert string "" to a double
null, line -1, column -1: Cannot convert string "" to a double
Cannot convert string "" to a double
oxf:/ops/xforms/xforms-server.xpl, line 38, column 95, description reading processor output: null, line -1, column -1: Cannot convert string "" to a double


Cannot convert string "" to a double
null, line -1, column -1: Cannot convert string "" to a double
Cannot convert string "" to a double</message>

Note that sum is failing and not the format,  Do you have any suggestions for this?

Regards,
Kannan

On 1/8/07, Ryan Puddephatt <[hidden email]> wrote:

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> <a href="http://www.teleflex.com/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">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

--
Regards,
Kannan Ekanath