You need to sign in to do that
Don't have an account?
Surya 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?
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