You need to sign in to do that
Don't have an account?
KNK
Formula field
Hi Team,
I am creating below formula filed in Account. Account and Object1 has a lookup relationship, but even though actual values are there in object1 it is showing null value in account
IF ( ISPICKVAL( object1__r.Type__c , "Actual") , Object1__r.Total_Volume__c , null)
/IF( ISPICKVAL( object1__r.Type__c , "Actual") , Object1__r.Total_Volume__c , null)
+IF( ISPICKVAL( Object1__r.Type__c , " ") , object1.Total_Volume__c , null) *100
please help me here ..
Hi,
Did you perform "Check Syntax" for the above. Did it pass the same ?
Just asking, because it looks like you have missed __r in the last line - object1.Total_Volume__c.
Regards,
Lakshmi.
It's typo error, syntax is correct
*object1__r.Total_Volume__c.
Hello there,
I read your post and wanted to know, are you trying to fetch the field from the child object ie object1 to Account, Let me be more clear so as per you say Account and Object1 has a lookup relationship, Form this I think, Account is parent and Object1 is child right?? If so then you won get the fields of child object in formula field, If this is Vice-vesa then wat you tring is possible.
Hopefully this was helpful!!
Thanks
Prady