Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Cant see your data or model but maybe try sum([2019])+sum([2020])
Cant see your data or model but maybe try sum([2019])+sum([2020])
Darn....forgot the [] thanks.