View Single Post
  #41  
Old December 7th, 2006, 02:47 AM
DeadMilkman's Avatar

DeadMilkman DeadMilkman is offline
Private
 
Join Date: Dec 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
DeadMilkman is on a distinguished road
Default Re: Component.txt Knowledge Base

Update: I found the problem with my original formula, I'm an idiot as usual, and missplaced a (.

So I have runs some tests, and all 4 of the methods discussed work as they should.
Method 1. using 40 - ( Int(([%Level%] - 1) / 7) * 10)
Method 2. using 40 - ( Trunc(([%Level%] - 1) / 7) * 10)
Method 3. using 40 - ( Round(([%Level%] - 1) / 7) * 10)
Method 4. using 40 - iif([%Level%] >= 19, 30, iif([%Level%] >= 15, 20, iif([%Level%] >= 8, 10, 0)))

Each method gives slightly different results as expected, except that Trunc and Int seem to be the same.

Hopefully this will be usefull to everyone.
__________________
It's not what you know...
It's not who you know...
It's what you know about who you know.
Reply With Quote