Generic Table

[tmumaw]

I have built a generic table which looks like this:

Sold To Customer          2019         2020

12345                                       1                1

45678                                       1                -

67890                                       -                1

I need to be able to sum 2019 value and 2020 value and get either 1 or 2, however when I try and construct the sum(2019) + sum(2020)  I get 4039.  Doing something wrong but not sure what yet.

Thanks

[jochem_zw · Accepted solution]

Cant see your data or model but maybe try sum([2019])+sum([2020])

[tmumaw]

Darn....forgot the []   thanks.