Fields wont sum in script

[#1]

Hi

Any possible solutions as to why two fields wont add in a script?

For example:

Tmp2:

load

*,

Budget1 + Budget2 as BudgetNew

Resident Tmp;

However, if I mulitiply or add to the fields Budget1 and Budget2 it works.

For example:

Tmp3:

load

     *,

     Budget1  * 2 as BudgetTmp1,

     Budget2 + 10 as BudgetTmp2

Resident Tmp;

Regards,

Magen

[#2]

can you then do this:

if(Budget1>0 and Budget2>0, Budget1+Budget2, Budget1) as SumOfBudgets