I am trying to create an SQL view that will display 2 sets of information:
- 1 extra column which the values will be the Concatenation of the values of 2 columns.
- Once I display this extra concatenate column I would like to get the SUM of values of the "Balance" column "IF" a criteria is met. The criteria is that the Concatenate value should be 551 and 572 AND the Period ID value is 1
Please refer to the example attached.
If you have any other recommendations on how to do this better, please let me knowDatabase.xlsx