Orbeon Forms community mailing list

Re: How to add a conditional attribute for a sum

Posted by Kannan Ekanath on
URL: https://discuss.orbeon.com/How-to-add-a-conditional-attribute-for-a-sum-tp32243p32249.html

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

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