This discussion is archived
5 Replies Latest reply: Apr 9, 2013 1:22 AM by newbi_egy

# formula of 10 text-items

Currently Being Moderated
db and dev 10g rel2 ,
hi all ,
i am trying to formula about 10 text-items , and it is not working , but if i formula only 2 text-items it is working well ?
why?
is there a maximum number of items to do formula .

thanks
• ###### 1. Re: formula of 10 text-items
Currently Being Moderated
Hi
is there a maximum number of items to do formula .
No there isn't.

Why don't you share your code with us. The two sets, the one that works and the one that doesn't.

rgds
Tony
• ###### 2. Re: formula of 10 text-items
Currently Being Moderated
:t11+:t12 works well
:t11+:t12+:t13+:t14+:t15+:t16+................ -- not working
• ###### 3. Re: formula of 10 text-items
Currently Being Moderated
If one of your fields is null then the whole result is null.

You need to use nvl(:abc,0) around each field.

Tony.
• ###### 4. Re: formula of 10 text-items
Currently Being Moderated
like so
nvl(:t11,0)+nvl(:t12,0)+nvl(:t13,0)
or like so
nvl(:t11+:t12+:t13,0)
?
• ###### 5. Re: formula of 10 text-items
Currently Being Moderated
nvl(:t11,0)+nvl(:t12,0)+nvl(:t13,0)

is the right way, if you use the other way then it will calculate the total as zero if any one of the field having none. So its better to convert each and every value cause we don't know which is having exactly

#### Legend

• Correct Answers - 10 points