i am trying to plot the difference between values of 2 dimensions. the 1st formula is works and I get a % for each Dimension (as table ). In another chart I want to plot the difference over time, but i always get zeros!! let me know if you see anything.
the problem is in the formula to calculate the difference. i always get a 0.0000 for the difference. here is my formula to calculate the difference. the Dimension is either a nchmark or a Portfolio, so this test is T/F
can you attacha workbook with fake data? I know you have confidential data, It is just to help you