Forum Discussion
To calculate the consecutive differences with the specific value chosen using FILTERS and Date slice
Hi folks,
I need help in calculating the cosecutive differences between rows with first rows fixed everytime with date slicer and Fund name. The calculations are as follows. Please help me.
| READY COLUMN | To Calculate the NEW Columns | ||||||
| Sno | Fund | Return | Price | Date | Start (Sno = 3) | ||
| 1 | A | 0.08 | 108 | 1/1/2019 | |||
| 2 | A | -0.06 | 101.52 | 1/2/2019 | Calculations - | ||
| 3 | A | 0.06 | 107.6112 | 1/3/2019 | |||
| 4 | A | -0.1 | 96.85008 | 1/4/2019 | -0.1 | 1 | To Fix the minimum value from COL-F based on minimum date of the slicer and "Fund A" |
| 5 | A | 0.03 | 99.7555824 | 1/5/2019 | -0.073 | 2 | For next all the filtered entries - take the differences from the first value of the column D baesed on the FILTERS of date and FUND(HIGHLIGHTED one) |
| 6 | A | 0.1 | 109.7311406 | 1/6/2019 | 0.0197 | ||
| 7 | A | -0.01 | 108.6338292 | 1/7/2019 | 0.009503 | ||
| 8 | A | 0.03 | 111.8928441 | 1/8/2019 | 0.03978809 | ||
| 9 | A | -0.03 | 108.5360588 | 1/9/2019 | 0.008594447 | ||
| 10 | A | 0.05 | 113.9628617 | 1/10/2019 | 0.05902417 | ||
| 11 | A | -0.02 | 111.6836045 | 1/11/2019 | 0.037843686 | ||
| 12 | A | 0.02 | 113.9172766 | 1/12/2019 | 0.05860056 | ||
| 13 | A | 0.07 | 121.8914859 | 1/13/2019 | 0.132702599 | ||
| 14 | D | 0.03 | 103 | 1/1/2019 | Same calculations for this fund also | ||
| 15 | D | -0.04 | 98.88 | 1/2/2019 | |||
| 16 | D | 0.02 | 100.8576 | 1/3/2019 | |||
| 17 | D | -0.02 | 98.840448 | 1/4/2019 | -0.040384 | ||
| 18 | D | -0.09 | 89.94480768 | 1/5/2019 | -0.12674944 | ||
| 19 | D | 0.04 | 93.54259999 | 1/6/2019 | -0.091819418 | ||
| 20 | D | -0.08 | 86.05919199 | 1/7/2019 | -0.164473864 | ||
| 21 | D | -0.07 | 80.03504855 | 1/8/2019 | -0.222960694 | ||
| 22 | D | 0.08 | 86.43785243 | 1/9/2019 | -0.160797549 | ||
| 23 | D | 0.09 | 94.21725915 | 1/10/2019 | -0.085269329 | ||
| 24 | D | 0.03 | 97.04377693 | 1/11/2019 | -0.057827408 | ||
| 25 | D | 0.08 | 104.8072791 | 1/12/2019 | 0.017546399 | ||
| 26 | D | 0.09 | 114.2399342 | 1/13/2019 | 0.109125575 |
2 Replies
Hi Anonymous ,
I'm a little confused by your description. Could you please share more detailed calculation logic for the "Start" column?
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
