2 Replies Latest reply on Jul 17, 2017 11:07 PM by Nayana Bhagat

# Calculate current and previous month cumulative count of measures

Hi,

I need to calculate the number of open requisitions that were created for a selected  month and also show the cumulative count of requisitions that were in the open status as of previous month.

For example, the requisitions created in Jan, Feb and March is say 7,3 and 5 respectively and all of them are still in the status of open as of March, I need to show a table as below.

So the first row here shows the open requisitions that were in open status as of a month which were carried forward for the current month and the second row shows the requisitions that were newly opened in that month only.

So far, I am able to achieve previous and current month open positions using parameters by selection of only one month and year. Please find the twbx file I have created for reference.

Would be really helpful if anybody could guide me to achieve the above.

Thanks,
Nayana

• ###### 1. Re: Calculate current and previous month cumulative count of measures

Hi Nayana,

I think I was able to achieve what you need by using a nested table calc to calculate Previous Month open number:

ZN(LOOKUP(RUNNING_SUM(COUNTD([Reqs Id])),-1))

Essentially, this does a "lookup" for the running sum of the count of open IDs, previous month.

Packaged workbook attached. Is this what you're looking for?

Michael

• ###### 2. Re: Calculate current and previous month cumulative count of measures

Thank you Michael!

This worked perfectly for me