Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
7 years ago

Formula Field variables set in an if statement

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 ...
RyanStanford1's avatar
RyanStanford1
Qrew Captain
7 years ago
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.