+ Start a Discussion
Karthik B.ax1475Karthik B.ax1475 

How can i calculate total

I have two field 

 

Quanity( Field type= Number)

Price(Field Type= Currency)

 

how can i calculateTotal(Field type=Currency)

 

When i try price__c.qua__c. It throws me "Error: Field price__c may not be used in this type of formula"

 

Can you please help me without changing field type.

 

Thanks,

Karthik

Steve MolisSteve Molis

You'll need to either change the Datatype from Currency to Formula(Currency) and use a formula like this:

Price__c * Qua__c

 Or if you're on EE or UE you could use a Workflow Rule and use the same formula to update your Currency field.

TrinayTrinay

Hi Karthik,

 

  The following steps will helpful to you,

Step-1 : Create a Numer field.

            Field label : Quanity , Field type : Number

 

Step-2 : Create a Currency field.

            Field label : Price, Field type : Currency

 

Step-3 : Create a Formula field and choose the retun type as a Currency.

            Field label : TotalField type : Formula

then add the Price__c * Quantity__c into the formula.Now when you save the record with quantity and price value, you will get the total in currency value.

 

I hope this will helpful to you.