Hi Henrik
Thanks for that, it works with me changing to double format
------------------------------
andrew darnell
Knowledge Community Shared Account
------------------------------
Original Message:
Sent: 01-22-2024 01:45
From: Henrik B
Subject: How to Sum 3 column value but can contain NULL
Can't you replace the nulls' with zeroes? so it becomes a valid object to perform int operations on?
And if you want to perform string operations i would replace the null's with an empty string.
------------------------------
Henrik B
E.ON Sverige
Original Message:
Sent: 01-21-2024 18:53
From: andrew darnell
Subject: How to Sum 3 column value but can contain NULL
Hi Support
I was hoping that someone could help me sum rows from 3 columns, but some values can contain NULL
------------------------------
andrew darnell
Knowledge Community Shared Account
------------------------------