Loading...
 
Features / Usability

Features / Usability


help with advanced formula

posts: 228 Ukraine

Hi,
I'm trying to break through to the next level of mathematical formulas for trackers by using 'if / and / or' functions. This is to calculate a price per kilogram for three categories -

if < 10kg = 10/kg (i.e. 3 x 10 = 30, or 7 x 10 = 70)
(so up to 9.9999)

if between 10kg and 20kg = 8/kg (i.e. 11 x 8 = 88, or 17 x 8 = 136)
(so from 10.0 - 19.999)

if > 20kg or greater = 6/kg (i.e. 22 x 6 = 132, or 33 x 6 = 198)

I was only able to create one possible formula for the first case, but it doesn't work ('f_289' is the numeric field for weight in kg)-

if (equals f_289 1 2 3 4 5 6 7 8 9 10f_289 10)

Is there a > or < function in Advance Rating?

Any help would be hugely appreciated,
Thanks
Mike


Upcoming Events

1) 
TikiFestParis2024
2)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  25 Jun 2024 16:00 GMT-0000
Data umbrella : Build Your First Database Web App with (open source) Tiki Trackers
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting