Skip to main content
Nintex Community Menu Bar
Solved

Results regarding percentages

J
Forum|alt.badge.img+10

Hello!

I am using a responsive O365 forms and having difficulties on the approach of percentages and decimals. I need to be able to determine if the result is less than 75%.

The first field is # of Months (integer) which is determined by the dates entered in from the fields above it. The other field is Asset Economic Life (integer) that is “driven” by the Category field and in which outputs 480.


I use the calculation below to provide the following output to the field in the second screen shot (displaying 12.08).

# of Months = TOTALS_Months

Asset Economic Life = Asset Economic Life

 

How do I even go about figuring out how to determine 12.08 is less than 75%??? I’m struggling on how to attempt this, please help!

I have the field above (holding 12.08) setup as so…fyi
 

 

Best answer by Garrett

Hi @jpacheco 

 

I would recommend you to to use the ifElse(,,) formula should you need to immediately display TRUE/FALSE or YES/NO string outcome.

ifElse( [Form].[Lease Term_Economic life of asset] < 75,"TRUE","FALSE")

 

 

 

View original
Translate
Did this topic help you find an answer to your question?

4 replies

Garrett
Forum|alt.badge.img+16
  • Garrett
  • Scout
  • 904 replies
  • May 30, 2024

Hi @jpacheco 

You have gotten the the correct value - “12.08” is “less than 75”

 

You could add another Text control to output Yes/No or TRUE/FALSE

Just add a new Form rule to compare whether the RESULT is LESS_THAN_75

 

Translate
J
Forum|alt.badge.img+10
  • jpacheco
  • Author
  • Scout
  • 82 replies
  • May 31, 2024

@Garrett ,

Thanks for your response! Ok, so even though if the output is in a decimal format like so…

 

The formula below will (should) return the following if I just add either < 75 or < 90?

First text field (L): Lease Term_Economic life of asset = 12.08
Formula: [Form].[Lease Term_Economic life of asset] < 75

 

Second text field (R): Total Lease Payments_Fair Value of asset = 30.72
Formula: [Form].[Total Lease Payments_Fair Value of asset] < 90

 

Translate
Garrett
Forum|alt.badge.img+16
  • Garrett
  • Scout
  • 904 replies
  • Answer
  • May 31, 2024

Hi @jpacheco 

 

I would recommend you to to use the ifElse(,,) formula should you need to immediately display TRUE/FALSE or YES/NO string outcome.

ifElse( [Form].[Lease Term_Economic life of asset] < 75,"TRUE","FALSE")

 

 

 

Translate
J
Forum|alt.badge.img+10
  • jpacheco
  • Author
  • Scout
  • 82 replies
  • May 31, 2024

@Garrett ,

 

OMG! Man, you’re amazing!!!! I’m still somewhat green but slowly seeing how this works is so cool! Thanks a lot, I really do appreciate your time and response on this… I’ve been working on this for a week now! 😅

 

YOU ROCK!!!

Translate
Garrett
1 person likes this
  • Garrett
    Garrett

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings