Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Could you provide a sketch of the desired chart and sample data for example in excel file?
regards
Darek