Customer experience | Sales, Customer Insights,...

Use of custom calculated field in Goal Rollup Query

(2) Share

Report

Posted on by Graham Phelps

Hi All,

I have scenario where I have had to calculate the actual qty of an order line depending on the description of the product.

For example if my order have three lines and each line has a qty of 2:

If the product description contains ‘one unit’ my Calculated Qty is the line Qty * 1 = 2
If the product description contains ‘two units’ my Calculated Qty is the line Qty * 2 = 4
If the product description contains ‘six units’ my Calculated Qty is the line Qty * 6 = 12

This issue I have is that I would then like to use this ‘Calculated Qty’ in my Goal Rollup Query, so that when the goal is looking for the total qty for these three lines, it it returning 18 and not the actual qty of 6.
Can this be done?

I have the same question (0)

All responses (4)

Answers (0)

Vahid Ghafarpour 12,220 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Did you try this guide?

How to Create a Calculated Field in Dynamics 365 (CRM) - Encore Business Solutions

Was this reply helpful? Yes No
Suggested answer

Muhammad.Affan Moderator on at

Like (5)

Report
Copy link

Link copied!

Hi There,

Refer these links:

https://learn.microsoft.com/en-us/dynamics365/sales/create-edit-goal-rollup-query-sales

https://learn.microsoft.com/en-us/dynamics365/sales/developer/roll-up-goal-totals

Thanks

Affan

Was this reply helpful? Yes No
MichaelTorres 86 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

You’ll need to create a custom-calculated field in Dynamics 365. Navigate to the customizations area in Dynamics 365. Create a new field for your order line entity and set it as a calculated field.

In the field’s properties, use a formula to evaluate the product description. You can use conditional logic (like an IF statement) to set the calculated quantity based on whether the description contains one unit, two units, or six units

Once your custom-calculated field is set up, you can incorporate it into your goal rollup query. This way, when the query runs, it will use the calculated quantity instead of the actual quantity, giving you the desired total

Hope it will help

Was this reply helpful? Yes No
Vahid Ghafarpour 12,220 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

** Please don't forget to close up the thread here by Like and verify it as an answer if it was solved **

Was this reply helpful? Yes No

Join the conversation

Community site session details

Use of custom calculated field in Goal Rollup Query

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Use of custom calculated field in Goal Rollup Query

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates