Lets’ say, this is how my table look like
| Week | 1 | 2 | 3 | 4 | WoW bps | |
|---|---|---|---|---|---|---|
| MP | ||||||
| US | 99.96% | 99.20% | 99.76% | 99.84% | 9 bps | |
| CA | 99.94% | 99.65% | 99.24% | 99.32% | 9 bps | |
| IN | 99.50% | 99.40% | 99.50% | 99.63% | 13 bps | |
| BR | 99.81% | 99.30% | 99.50% | 99.56% | 6 bps |
My current week keeps on changing and i want to show only the difference between current week vs previous week (where the values are in %) in bps. These % values are also from a calculated field. Could you please help me create a calculated field for this?