You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cap “Percent Spent” calculation for revenue at 100% in Project Process Configurator

in Revenue Management

Summary:

We have a requirement to exclude a specific expenditure type for calculating the percent spent revenue. Due to this requirement we are not able use the seeded percent spent billing extension.

We have used the Project process configurator to create a formula to calculate this value and using the formula shown below.

((( "CalculationLevelLaborRawCostinProjectFunctionalCurrencyITD"+ "CalculationLevelNonlaborBurdenedCostinProjectFunctionalCurrencyITD")/ "CalculationLevelPlannedBurdenedCostinProjectFunctionalCurrency")* "AssociatedProjectFundingAmountinContractCurrency") - "CalculationLevelEventRevenueinContractCurrencyITD"

We have applied a filter on the Nonlabor cost to exclude the expenditure type and we have added a filter on the source for Planned burdened cost as Cost and Revenue Forecast.

The issue with this formula is that the calculation does not cap at 100% like how the seeded extension does.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!