Formula Field variables set in an if statement

Question

I am trying to assign a variable value in a formula field... but with the catch that the criteria is if a number is greater than 0... Example:

If([Branch - H&W Deferred Rate]>0,

var number Rate = [Branch - H&W Deferred Rate];,

var number Rate = [Branch - H&W Cash Rate];)

I've attempted the Case Switch... but that didn't work the way I need it to.

quickbasecoachd · Answer

Formula variables are great but in this case they are not necessaryIf([Branch - H&amp;W Deferred Rate]&gt;0,[Branch - H&amp;W Deferred Rate], [Branch - H&amp;W Cash Rate])

ryanstanford1 · Answer

Normally you would be accurate... but I'm setting the variable, as depending on the criteria, determines which values I need for calculations in this formula.

ryanstanford1 · Answer

I was able to figure out the solution... Please see below:

var Number Rate = If([Branch - H&W Deferred Rate]>0, [Branch - H&W Deferred Rate],[Branch - H&W Cash Rate]);

This was part of a huge calculation field, hence why I wanted the use the variable here.

Forum Discussion

Formula Field variables set in an if statement

Related Content

formula help "if statement"

Using variables with class='SaveBeforeNavigating

Dynamic Rule - Or statement?

Jinja If statement equals field value

Total Formula with 2 IF statements