Skip to main content

Hello, I currently have this question needing to solve "If a branch's average monthly gross revenue in the last quarter is higher than $1500, its revenue split rate will be 80%, or else it will be 70%"

I want the result to show Percentage 80% and 70% as result because after that I will use them to calculate the net revenue. ASAP. Thank you.

Hmm, what problems are you facing with setting this up?  I've set something up here for you to check out to see if it helps

 

Hi @maddieyoung27,

Give this a try

IF({Q2 avg month revenue} > 1500, 0.7, 0.8)

Then set the formula field formatting to percentage:


Reply


Terms & Conditions