Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
load
Num#(Budget1 ,'##.###') + Num#(Budget2 ,'##.###') as BudgetNew
resident temp;