How to create a key figure to calculate lost opportunity month wise based on up to start date in C4C

[Former Member]

Hi,

My requirement is to create a key figure to calculate the lost opportunity in a specific month based on up to start date.

ex. 1. key figure(Jan 2018)= lost opportunity up to Jan 31st 2018/Total opt up to Jan31st 2018.(start date)

2.key figure(Dec 2017)= lost opportunity up to Dec 31st 2017/Total opt up to Dec31st 2017(start date)

Is it possible to create a key figure like this in C4C. Please suggest.

[VinitaSinha]

Hi,

To calculate Lost revenues, you can create a restricted key figure. Eg: Restricted Key Figure on Expected Value, with a Fixed Value Restriction on Status = lost. For the Dates, you could also restrict them to something more generic say current month etc. Else, use dates in the selection parameters of the report in which you would use this key figure

Thanks

Vinita