function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
vandemanjwvandemanjw 

Calculate Billing for Different Services?

I'm working on calculating an amount to be billed to a client, which is different based on the service:

 

CASE(Payment_Terms__c, "Hourly Rate",(Billable_Hours__c*Amount), "50% on Contract, 50% on Completion", (0.5*Amount), "Monthly Reoccurring Rate", Amount,0)

  

Picklist: Payment_Terms__c

Picklist Options: Hourly Rate, 50% on Contract, 50% on Completion, Monthly Reoccurring Rate

 

Each is calculated differently:

Hourly Rate = Billable_Hours__c multiplied by Amount

50% on Contract, 50% on Completion = Amount multiplied by 0.5

Monthly Reoccurring Rate = Amount 

 

Any thoughts?  Thanks!