Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Baldaia
Contributor II
Contributor II

sum value with a percentage of it

Hi,

i want to sum a value to 10% of it, like this

[Target] + 10% of [Target]

How i do that?

 

Then i will compare it to another value like this:

 

If([x] <= [Target], '1',
If([x] <= ([Target] + 10% of [Target]), '2',
'3'))

thx

Labels (3)
1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @Baldaia 

Try:

If([x] <= [Target], '1', If([x] <= ([Target]*1.1), '2','3'))

Regards,

Mauritz

View solution in original post

2 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @Baldaia 

Try:

If([x] <= [Target], '1', If([x] <= ([Target]*1.1), '2','3'))

Regards,

Mauritz

Baldaia
Contributor II
Contributor II
Author

Just perfect!

thank you