Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Merge 2 columns thar contain zéros
12-02-2023
12:19 PM
Hello
I found this interesting tip which works with columns when the values contain null
In this example I would like to keep the zeros and the code doesn't work.
Is there a trick that doesn't require an if ?
Thanks in advance
Best regards
Debit Credit
12 0
45 0
0 21
52 0
19 0
85 0
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2023
12:59 PM
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2023
09:56 PM

Yes, it's a great way to learn and one that you'll never forget,
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2023
12:59 PM

Just Add a Custom Column:
Name: Result
Formula: = [Debit] + [Credit]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2023
01:18 PM

Hello @ronrsnfld
I'm ashamed when I see the solution and I say to myself, why didn't I think of this 😀
Thank you
Best regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-02-2023
05:27 PM

I have done many "head slaps" over the years.

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
05-24-2025 12:00 PM | |||
09-11-2024 04:22 AM | |||
06-02-2025 03:46 PM | |||
Anonymous
| 07-28-2016 08:34 PM | ||
05-19-2025 02:02 PM |
Top Solution Authors (Last Month)
User | Count |
---|---|
11 | |
7 | |
5 | |
5 | |
4 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
16 | |
14 | |
8 | |
6 | |
6 |