+ Start a Discussion
apex code shareapex code share 

Please help me writing a formula

I have a custom object-Scheme line(which has three record types i.e mechanics,reborer and  Retailers)  in this i have   fields Denomination and Quantity.

 

Now i want to have formula fields :-  value for mechanics,value for Reborer,value for Retailers {which is Denomination * Quantity(say 50*10)}

 

but in the field (value for mechanics) i want only those value which is filled in the fields (Denomination and Quantity) of record type of mechanics only

Simmilarly, for Value for Reborer will have values filled in the fields (Denomination and Quantity) for the the record type reborer only


 


atul_Bharmalatul_Bharmal

You can write three formula fields.

 

Now in every field write code as below

 

if(ispickval('Fieldname__c'',text')50*10, 0)

 

same with othere fields

 

Do mark as correct if it helps