I am hoping someone can assist with a way of obtaing a "Float Variance". This is the difference between today's Opening Float less yesterday's Closing Float. The attached qvw has a simple Fact table as well a a Daily1 table which is where I have tried using the expression "sum(opening_float - previous(closing_float)" to create the Float Variance value.
In the Fact1 chart I am using the expression "sum(opening_float - above([Closing Float])" to prove my variance, but in the solution this cannot work because when I select business day 2374, the variance disappears.
Ideally I need to select a day, 2347, and it should return the opening, closing and variance values for the day. The final solution will have a dash with a textbox showing the values.
I appreciate your assistance. Thank you in advance - John
