So I have two tables joined together. One table lists jobs where an amount was reversed. The other table lists jobs where an amount was invoiced.
I am trying to find a way to show the amount billed that occurred between different reversal dates.
In the example below, since the rebill occurred on 3/16/2023, my measure when put into the Reversal table should show a rebill amount of $0.00 on the first 3 reversal lines and then $10,000 on the last line.
Using the same example as above, but say the rebill date is 2/16/2023, then lines 1,2,4 on the reversal table would show $0.00 in my Rebill Measure and $10,000 on the third line.
I would suggest switching the signage of the reversal amount in PQ on the reversal table and add a Column headed “Type” filled with “Reversal”.
Then add a column headed “Type” to the Rebill table filled with “Rebill”. Change the reversal date and rebill date to read just “Date”. Then append the two tables.
Now all the transactional data is in 1 table. Link this to a date table and all should be fine.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!
