Here is the scenario:

For every deal that is signed there is a commission pool of 2 to 6 people. The commissions are paid out as the money comes in each month. The customer payments from which the commission payments are made may or may not be large enough to completely pay the commission amounts in month. In that case the remainder rolls over to the next month Example:

Dealer Commission Due: 300
Customer Monthly Payment: 200
September Commission payment:200
October Commission payment: 100

And so on.

I have written a bunch of IF(AND and IF(OR formulas to automatically calculate the payments to be made (depending on funds availability, etc).

My problem is that I am bumping up against the 5000 limit for formulas. I need a way to take the value of a formula (let's say the September Commission Amount) and use that in a new formula.

So the assumption would be that I am taking the value of a field, not the formula itself into the next formula, breaking the chain of formulas and 'resetting' the 5000 character limit????

Does this make sense?

How do I do this? I tried using the Mail Merge Value {!fieldname_c} but it did not disconnect me from the formula chain.

I have several of these complex formulas to create. Using SF Professional.

Thanks for your time, you brilliant people!

David

Hi All,

I am creating an scontrol to pass information from 1 object to another.. basically I want to have a "create invoice" button in an account that sends the account name and address to the invoice.. The problem i'm having is that the "billing address" field has 3-4 lines in it, therefore when the scontrol redirects to the URL https://salesforce....{account.name} + .. {account.Billingaddress} it errors as there are multiple lines on the billing address..

Does anyone know how I can send this billing address to the invoice billing address?? I've got team/group edition

Many thanks

Eoin
Dublin
Ireland

A cohort of mine is working on a custom formula in salesforce and is experiencing difficulty as the formula is beyond the scope able to be handled (he believes the limit to be somewhere around 5K). He has tried to break up the formula into separate components, but once again has run into difficulty with it being beyond the scope of things. His actual question to me is:

I think what I want to do is break it up into seperate formulas, but even referencing those formulas makes it too long - is there any way to reference the actual VALUE in a formula field and not the formula itself from another formula?

Has anyone out there in our salesforce universe experienced a similar situation and if so, can you help out with how you implemented the solution? Thanks!

-Larry @ cars.com