Forum Discussion
Solved
Merge data from two columns into one
Background: Our transactions are booked using either project codes or cost center (CC) (not both). Ultimately the project codes roll to specific CC. So I want to be able to show a total spend by CC r...
In the query editor try adding a conditional column. In the dialog, IF CC > 0 Then CC Else Select a Column -> Derived CC
In the query editor try adding a conditional column. In the dialog, IF CC > 0 Then CC Else Select a Column -> Derived CC