Forum Discussion
SpiroswayGR
Resolver III
Resolver IIIDifficult Task - Cumulative but Net Difference
Dear Community, Let me explain the problem. 1st : We have Data from Hotel Reservations 2nd: We want to Sum Net Difference of reservations and cancellations (Reservations - Cancellations) 3rd :...
SpiroswayGR , You can join both dates with the same date table. One Active and One Inactive join will be there. You can use userelation to choose the join
amitchandak
Super User
Super UserSpiroswayGR , You can join both dates with the same date table. One Active and One Inactive join will be there. You can use userelation to choose the join
SpiroswayGRResolver III
Resolver IIIamitchandak Looks like that is the solution that i am looking for.
I will try to apply it on my data. In case , that is not working on me . Can i share some "fake data" to help me around with solution ?
Thanks in advance