Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Sales forum / Use of custom calculat...
Sales forum
Suggested answer

Use of custom calculated field in Goal Rollup Query

(1) ShareShare
ReportReport
Posted on by Graham Phelps 91
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?
Categories:
Sales Goal Management
  • MichaelTorres Profile Picture
    MichaelTorres 24 on at
    Use of custom calculated field in Goal Rollup Query
    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
  • Suggested answer
    Muhammad.Affan Profile Picture
    Muhammad.Affan 1,631 on at
    Use of custom calculated field in Goal Rollup Query
  • VaHiX Profile Picture
    VaHiX 869 on at
    Use of custom calculated field in Goal Rollup Query

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,435 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans