Ad of two columns doens't work

[Anonymous]

Hi all,

i have the following script:

TEST:

LOAD

     [Umsatz Soll] + [Umsatz Haben] as Umsatz_Gesamt

resident xxx;

But it doesn't work.

The column "Umsatz_Gesamt" ist empty.

Any ideas what i do wrong??

Thank u

[vishsaggi]

Try this?

LOAD

     [Umsatz Soll] & '-' & [Umsatz Haben] as Umsatz_Gesamt

resident xxx;

[el_aprendiz111]

Hi,

1 Example

Tab:
Load * inline [
Name, NameTwo
RR,ZZ
RR,HH
BB,JJ
CC,OO
BB,PP
];

Table:
LOAD Name & '-' & NameTwo as NewField
,*
Resident Tab;
Drop Table Tab;

[awhitfield]

Hi Robert,

what' the data in xxx look like?

andy

[sunny_talwar · Accepted solution]

Does [Umsatz Soll] and [Umsatz Haben] include numbers? Are you trying to sum the two numbers up? May be try using RangeSum()

TEST:

LOAD

    RangeSum([Umsatz Soll], [Umsatz Haben]) as Umsatz_Gesamt

Resident xxx;