+ Start a Discussion
Abhijeet Purohit01Abhijeet Purohit01 

Problem in the formula field.

There are 3 objects:


1. Quote: Standard Object

2. Quote Line Item: Standard object

3. BOQ Item: Custom object.



i>  BOQ Item is in a Master Detail relationship with BOQ. BOQ Item is detail object in the relationship.

ii> BOQ is in a look up relationship with Quote Line Item.

iii> There is a picklist field in the Quote Line Item called Rate Basis.

iv> I have created a formula field in the BOQ Item with the following formula:



There are no errors in the formula but at the same time no value is getting displayed.



What could be the problem?

Kindly help



Best Answer chosen by Admin (Salesforce Developers) 

Try both valid and invalid test data for your testing.

Try to simply the formula to see the level on which it fails, take it appart piece by piece and put them togheter till it fails(create other formulas - like another one TEXT (Rate_Basis__c) on Quote_Lookup__c object and reference that one the BOQ).

See if you don't have other validations, wf, triggers that affect your data...


Hope this helps,