+ Start a Discussion
KNKKNK 

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 ..

lakslaks

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.

KNKKNK

It's typo error, syntax is correct

 

*object1__r.Total_Volume__c.

Prady01Prady01

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