Calculation that uses number of months

[Former Member]

All,

I am trying to do the following report:

0CALMONTH...KF...# days in 0CALMONTH...KF/daysInMnth

006/2006........15......30..................................15/30

007/2006........10......31..................................10/31

Any ideas on how to get the number of days according to the 0CALMONTH?

Thanks,

Chris

Message was edited by: Chris Hallowell

Message was edited by: Chris Hallowell

Message was edited by: Chris Hallowell

[Former Member · Accepted solution]

- Virtual KF.

- VBA Macro (if running in Excel) to get no of days, and, the calculated KF column.

Not sure if any easier option exists.

[Former Member]

Thanks guys, I will try the virtual key figure route.

[former_member184494]

Chris,

As suggested you could use a Virtual KF or have the field in your update rules and have the same routine for Virtual KF there and use the same in your report.

Arun