3 Replies Latest reply on Jun 29, 2016 7:14 PM by Shinichiro Murakami

# IF statement help

Hello All,

I hope this message finds you all well.

I'm in need of some help. Here is what I'm trying to accomplish:

I'm trying to write an IF statement that will look at each category in my graph (License, ME&S, and Trial) and IF all categories for the Zone are above 60% THEN "Above Benchmark". IF <60% or blank then "Under Benchmark".

So on the attached, the only zone that meets this criteria is GSF

I'm struggling as I do not think the following is the best way to solve...."IF Category = "Trial" and EASy Utilization > .60 and Category - "ME&S" and EASy Utilization > .60......there has to be a better way!

Thanks for your time.

Regards,

Mikey

• ###### 1. Re: IF statement help

Considering you are using version 8, only the way I know is creating multiple fields.

If you can upgrade, after, version 9.0 yo ucan use LOD to calculate same thing.

[Order Value (USD) License]

if [Category]="License" then [Order Value (USD)] end

[Order Value (USD) ME&S]

if [Category]="ME&S" then [Order Value (USD)] end

[Order Value (USD) Trial]

if [Category]="Trial" then [Order Value (USD)] end

IF ATTR([EASy?])="Yes" THEN COUNT([Order Value (USD) License]) / TOTAL(COUNT([Order Value (USD) License])) END

[EASy Utilization ME&S]

IF ATTR([EASy?])="Yes" THEN COUNT([Order Value (USD) ME&S]) / TOTAL(COUNT([Order Value (USD) ME&S])) EASy Utilization TrialEND

[EASy Utilization Trial]

IF ATTR([EASy?])="Yes" THEN COUNT([Order Value (USD) Trial]) / TOTAL(COUNT([Order Value (USD) Trial])) END

Then,

[Calculation2]

IF ([EASy Utilization License]) > 0.6

and [EASy Utilization ME&S] >0.6

and [EASy Utilization Trial] > 0.6

THEN "Above Benchmark"

END

Thanks,

Shin

8.3 attached.

• ###### 2. Re: IF statement help

Thank you so much, SHIN!

• ###### 3. Re: IF statement help

You are welcome.

Hope you can get version 9.0 or higher soon.

Shin