+ Start a Discussion
Surya Prakash TomarSurya Prakash Tomar 

In"Quote line item" Object "Total Price" field is not Visible in formula fields

Hi Team,

In "quote line item" Object i need to create one formula fields that are showing the "Total Price" field value but am not able to do this because In "quote line item" Object  "Total Price" field is not Visible in formula fields?

Please let me know this is the limitation from the salesforce side or any suggestion?

RKSalesforceRKSalesforce
Hi Surya,

I hope this would work.

Total Price does not appear to be a field that can be inserted into formulas, but you can create a Custom Field within the Quote Line Items object that calculates Total Price as follows:

( (  Quantity *  PricebookEntry.UnitPrice * (1 -  Discount ) )

For example, I wanted to calculate margin AFTER discounts were applied, so I created the following formula Custom Field within the Quote Line Items object:

( (  Quantity *  PricebookEntry.UnitPrice * (1 -  Discount ) ) - CUSTOM_COST_FIELD ) / ( PricebookEntry.UnitPrice *  Quantity ) .

I created the CUSTOM_COST_FIELD by creating a Custom Field that multiplies UnitPrice * (1 - Margin).

Please let me know if helped.

Regards,
Ramakant