1 Reply Latest reply: Apr 11, 2014 5:40 PM by Dariusz Mielczarek RSS

    Expression in chart question

    Matt Maino

      Hi everyone,

       

      I'm wondering if a specific bit of logic is achievabe by using expressions. I have fields that represent a date(which is monthly), current balance, and days past due - for each date there are several current balances. For each date I would like to capture the sum of all current balances just on that date that fall within a specific range of days past due, then divide that by the sum of all current balances on that specific date (reguardless of amount of days past due). This will result in a percentage of current balance dollars that fall within a specific date range. I want to graph this in a static way so that if I select a specific date range the graph will not change, and instead just zoom in. Does anyone know if this is possible?

       

      Thank you.