SAP Fields wont add in script

Mon, 26 Jan 2026 21:26:37 GMT

Magen Vadivelu asked3 hours ago

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

Re: SAP Fields wont add in script

Anonymous — Tue, 30 Sep 2014 03:18:13 GMT

Try this:

load

Num#(Budget1 ,'##.###') + Num#(Budget2 ,'##.###') as BudgetNew

resident temp;