Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I need to figure out the best logic to calculate the difference between two rows.
for example :-
Week | 1 | 2 | 3 |
Count of Yes | 100 | 200 | 250 |
Count of No | 20 | 50 | 100 |
Week | 1 | 2 | 3 |
Drop off Yes | 100 | 50 | 0 |
Drop off No | 30 | 50 | 0 |
The values for Count of Yes and Count of No are appeared based on filter selections.
I just need to figure out the logic for calculating Drop off Yes and Drop off No.
Logic for Drop Off Yes = Count of Yes(2) - Count of Yes(1) ie. 200-100=100
Logic for Drop Off No = count of No(2) - Count of No(2) ie. 50-20=30
Let me know if you have question.
Would you be able to share a sample to where we can see what you have?
Sorry Sunny!
At this moment i have got only this scenario.
I am looking to build something with same scenario mentioned, so wanted to get ideas on that.
is it possible to be done ?