Qlik Community

QlikView Connectors

Not applicable

SAP Fields wont add in script

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

1 Reply
yfe
Contributor III

Re: SAP Fields wont add in script

Try this:

load

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

resident temp;

Community Browser