Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Yes, it's a great way to learn and one that you'll never forget,
Thank you
Just Add a Custom Column:
Name: Result
Formula: = [Debit] + [Credit]
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
I have done many "head slaps" over the years.