Apex Code Development You need to sign in to do that
Don't have an account?
Abhijeet 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:
Text(BOQ__c.Quote_Lookup__r.Rate_Basis__c)
There are no errors in the formula but at the same time no value is getting displayed.
What could be the problem?
Kindly help
Abhijeet
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.
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 ) )
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..?
HI. Please see my another post related to WorkFlow. This is a part of the Problem related to WorkFlow post.