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

Unable to put Decimal points for Integer number values for Number formula field.

Received Response
41
Views
2
Comments

Summary:

As per Business requirements, needed the Number formula field at Subscription Product called "Annualized TCV" value to return calculated integer values in form of double with decimal points. For eg:- 25 should be store in form of "25.00" so it matches with TotalContractValue OOTB field.

Version (include the version you are using, if applicable):

23C (11.13.23.07.0)


Code Snippet (add any code snippets that support your topic, if applicable):

Groovy Script of Number Formula field:

if(MonthlyRecurringRevenue != null)

{

Double mrr=(MonthlyRecurringRevenue*1.00d).doubleValue();

Double tcv=TotalContractValue.toDouble();

Double acv=mrr*12.00d;

if(acv >= tcv)

{

acv = tcv*1.00d;

}

String acv1=String.format("%.2f", acv);

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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