SAP Fields wont add in script

[#1]

Fields wont sum in script in App Development

Magen Vadivelu asked3 hours ago

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

[Anonymous]

Try this:

load

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

resident temp;