Now I want QV to calculate the longest period per Id in which sequal months show the Ratio-data (aging). For C10 this would be 4 months and a total of 94 and for C21 this would be 3 months and a total of 105. Ideally, I would want the user to be able to use a variable to set the current date (or select it) and QV then looks back from that data on to find the longest continuous range. Any suggestion on how to do this? Thanks! Sander.
