Currency Formula (Currency to Text)

I am trying to make a dollar value show from opportunties to a custom object. Conditions if a check boxc(Free Seat) returns true then null the dollar amount, if not then pull the value from Opportunity__r.Effective_Billing__c.

Opportunity__r.Effective_Billing__c is a Currency field.
The field i am populating is Average_Billing_Rate__c is a text field.
Free_Seat__c is a Checkbox.

Logic: populate the effective billing rate from the opportunity to the internship object. If the free seat checkbox is checked than average billing rate should read $0.00

Also, I will need the $ and the decimals in the formula because this goes in to an accounting system.

I am running in to IF problems when i add &&
I am running in to IF problems when i add ||
Extra problems with ,. &" $" &
Extra problems with ,. &" . """ &
Running in to problems all around basically.

August 18, 2015
·
Like
0
·
Follow
1

Best Answer chosen by Jason McCarthy 2

Neetu_Bansal
Hi Jason,

I am assuming Average_Billing_Rate__c is a formula field of return type text. so you can use the formula:
IF( Free_Seat__c , '$0.00', '$'+TEXT(Opportunity__r.Effective_Billing__c))

If Average_Billing_Rate__c is not a formula field, you have to populate it via either Workflow Rules or triggers.

Thanks,
Neetu

August 18, 2015
·
Like
0
·
Dislike
0

This was selected as the best answer

Jason McCarthy 2
Excellent answer. thank you. I was adding true to the IF clause and it was erroring out.

August 19, 2015
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Currency Formula (Currency to Text)

All Answers

You need to sign in to do that.