7 Replies Latest reply on Sep 13, 2018 11:51 PM by Steve Martin

# how to get 1 result if it is less than 5% ?

Hi guys can you help me getting 1 result if it is less than 5%? Can't get the correct calculation

Thank you

• ###### 1. Re: how to get 1 result if it is less than 5% ?

Hi Benjie,

Please can you clarify what exactly you are trying to do.

Steve

• ###### 2. Re: how to get 1 result if it is less than 5% ?

i want to get 1 value in the hit calculation if the result of the percentage is less than 5%

for example:

you can see in the screenshot the one with the arrow has a percentage, if that percentage is less than 5% the result in the circle should be 1 not 0.

@

• ###### 3. Re: how to get 1 result if it is less than 5% ?

Hi Benzie,

Please find the solution in the attached twbx.

thanks

1 of 1 people found this helpful
• ###### 4. Re: how to get 1 result if it is less than 5% ?

Thanks for the help Pavan

is there a way that we can do that horizontal? same format like in the screenshot

• ###### 5. Re: how to get 1 result if it is less than 5% ?

Hi Benjie,

Try the attached.

Steve

1 of 1 people found this helpful
• ###### 6. Re: how to get 1 result if it is less than 5% ?

Thank you Steve

• ###### 7. Re: how to get 1 result if it is less than 5% ?

Thats fine Benjie,

Did you happen to take a look at the solution I suggested? I ask as this provides the output exactly as you requested such that your feedback would be useful to other forum users that may happen across this thread.

Steve