+ Start a Discussion
Abhijeet Purohit01Abhijeet Purohit01 

Problem with 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



Jeff TalbotJeff Talbot

Strange that it isn't producing an error. Try changing "BOQ__c" in your formula "BOQ__r".


Hi TA_Invisible !


Actually I tried the same there is no error.The field is also present in the page layout and visible .

But when BOQ item record is created following the BOQ related list ,that particular value is not being populated .


But the reason why this is not being populated it's still not clear .


Few more ideas i have let me try those first.

  1. Rate_Basis__c is which data type.
  2. can u remove text() and test in once.
Abhijeet Purohit01Abhijeet Purohit01

Rate_Basis__c is of type PickList


In case of picklist fields removing TEXT tag will throw an error .


TEXT( ISPICKVAL( BOQ__r.Quote_Lookup__r.Rate_Basis__c ) )



Abhijeet Purohit01Abhijeet Purohit01

NO!! But how can you use a ISPICKVALUE() function with only one parameter? I think it needs two parameters.


Oh sorry


But, Dint TEXT(BOQ__r.Quote_Lookup__r.Rate_Basis__c) this work..?



Abhijeet Purohit01Abhijeet Purohit01

HI. Please see my another post related to WorkFlow. This is a part of the Problem related to WorkFlow post.