You need to sign in to do that
Don't have an account?
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
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