-
1. Re: IF statement help
Shinichiro MurakamiJun 28, 2016 7:04 PM (in response to Mikey Michaels)
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.
LOD
Overview: Level of Detail Expressions[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
[EASy Utilization License]
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.
-
EASy_Rolling 3mo_HELP 8.3.twbx 41.5 KB
-
-
2. Re: IF statement help
Mikey Michaels Jun 29, 2016 6:43 PM (in response to Shinichiro Murakami)Thank you so much, SHIN!
-
3. Re: IF statement help
Shinichiro MurakamiJun 29, 2016 7:14 PM (in response to Mikey Michaels)
You are welcome.
Hope you can get version 9.0 or higher soon.
Shin