Formula (Calculated field) assistance

(3) Share

Report

Posted on by AM-14021633-0

In Dynamics 365 I've created a calculated field as follows:

'Probability (closeprobability)'*(Decimal('Est. revenue')/100)
 
This formula is intended to report a weighted sales amount based on the estimated revenue * the probability of sale.  The formula works well but it results in a whole number.  Is it possible to format the answer as currency with 0 decimal places?
 
Thank you.

Categories:

Dynamics 365 general

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Daivat Vartak (v-9d... 7,841 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hello AM-14021633-0,

You're on the right track with your calculated field! The reason you're getting a whole number is because you're dividing Decimal('Est. revenue') by 100, which results in a decimal value, but the calculated field then likely defaults to an integer or whole number format.

Here's how to format your calculated field to display the result as currency with 0 decimal places:
1. Adjust the Formula (Slightly):
Instead of dividing by 100 in the formula, you can multiply by 0.01. This will achieve the same result but might provide better compatibility with currency formatting.
Your formula should look like this:

'Probability (closeprobability)' * Decimal('Est. revenue') * 0.01

2. Set the Field Format:

Go to Customizations:

Navigate to Settings > Customizations > Customize the System.

Locate the Calculated Field:

Expand Entities > Opportunity (or the entity where your calculated field is located) > Fields.

Find your calculated field.

Edit the Field:

Open the calculated field.

Set the Field Type:

Ensure that the Field Type is set to Currency.

Set the Precision:

In the Format section, set the Precision to 0.

Save and Publish:

Save the field and publish your customizations.

Explanation:

Currency Field Type: By setting the field type to "Currency," Dynamics 365 will automatically format the result as currency.

Precision: Setting the precision to 0 will remove the decimal places.

Important Notes:

Data Type Compatibility: Ensure that the Est. revenue field is also a currency field or a decimal field.

Testing: Thoroughly test your calculated field after making these changes to ensure that it displays the correct currency format.

Publishing: Remember to publish your customizations after making changes to the field.

By following these steps, your calculated field should display the weighted sales amount as currency with 0 decimal places.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Best Regards,
Daivat Vartak

Was this reply helpful? Yes No
Verified answer

Tom_Gioielli 3,084 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Formula fields do not yet support currency fields being used to calculate other currency fields (and formula fields do not give the option to set the field type).

Work with Dataverse formula columns - Power Apps | Microsoft Learn

You might have better luck with a classic calculated field (which you can define as currency when creating it) and should be able to handle that calculation. Otherwise, a non-calculated field populated via workflow, cloud flow, plugin, dataflow, or some other automation would be best.

If this answer helped, please consider marking as verified.

Was this reply helpful? Yes No