Skip to Content
Former Member
Jul 20, 2009 at 07:00 PM

Date Variable as Key Figure


I would like to have a user enter a Key Date for an accounts receivable report and show open items based on this key date. I would also like to display the number of days an item has been open as of the key date. To do this i need to subtract the posting date (characteristic which is used as a key figure) from key date variable value. For example if a user selects a key date of 7/10/2009 and the item was posted on 7/3/2009 the report should have a key figure column with a value of 7.

Any help would be appreciated.