Forum Discussion

JakeJake's avatar
JakeJake
Qrew Trainee
7 years ago

Combining Formulas

Hello,

I posted a question and got this answer:

([Payment Amount]-[Client Fee Due]-Nz([Override Due]))/2

This was VERY helpful; however, I would like to also do an override on certain sales groups.  Here is what I suggest but there is an error.

If([Marketing Rep],= "SALES REP A", [Payment Amount]*.07)

or

([Payment Amount]-[Client Fee Due]-Nz([Override Due]))/2

Thanks for your help!

12 Replies

Sort By
Show More
  • JakeJake's avatar
    JakeJake
    Qrew Trainee
    7 years ago
    It breaks on the comma.  I can put in a support case if you want me too.
  • EvanMartinez's avatar
    EvanMartinez
    Qrew Elite
    7 years ago
    Hi Jake,

    At this point I would suggest a Support Case just to be sure. A Care Team member can take a look at it with an invite to the app and see what is going on since the screenshot didn't seem to work. Then they can help you troubleshoot the formula. Sometimes seeing it in the app environment helps to put the error into context since the suggested changes didn't stop the error.