Track deals that have a guaranteed minimum for a specific product

[KWhelan]

Our finance team wants to be able to track deals that have a guaranteed minimum for a specific product. We don't have this for every deal. Ideally, they'd easily be able to see "unit price" * "amount of the minimum" for the guaranteed amount of revenue. It doesn't look like I can create a calculated field on the deal record that multiplies a deal property and a line item property. I've tried creating a workflow to copy the line item unit price over to a new deal unit price field but I'm struggling to do that as well. Any thoughts?

[GreyHamilton · Accepted solution]

Hello @KWhelan,

I may need some more information about the structure of how you're tracking the minimum amount on the line item, but I think the solution might just be utilizing two calculated fields.

If the Guaranteed minimum has a price that sits on the line items already you can do a calculated field on the Deal to roll up that information first, then do another calculated field to do that Minimum * Amount.

First calculated field to pull from the Line item:

2nd calculated field:

If you aren't using a specific field to track this number and instead some of the line items are guarenteed or not you could first added a Line Item property that would allow us to signify it has a guaranteed minimum.

Then I created a calculated field to pull the sum of the associated Line Items with the condition that Guarenteed Minimum is checked.

In testing on the Deal / Line items, here is those listed utilizing that check.

With the above line items we get this result for the roll up field.

You can then create another calculated field to get your final 

Hopefully this steers you in the right direction. If this doesn't solve your issue let me know how the minumum guarenteed part is being tracked.

[kvlschaefer]

Hi @KWhelan,

Thanks for reaching out to the Community!

I've moved your reply to a new post to ensure it gets visibility among our community members.

Let's invite our subject matter experts to this conversation.

Hi @karstenkoehler, @jolle, @GreyHamilton - Do you have any workflow or calculated property tips for @KWhelan? 

Thank you!

Best,

Kristen