Where condition record need to be maintained like..
upto 1kg say 10 rs
upto 2kg 12 rs
upto 3 kg 15 rs
Without any specific patter in Cost.
now for weight 3+ kg i wanna charge 5rs/kg.
eg Freight for upto 4 kg 20
upto 5 kg 25
upto 6 kg 30
till say 100kg maximum.
Now, how should i maintain the condition record for this?
I tried creating a scaled ID with calculation type T.
for 1,2 & 3 kg we can have absolute Value & To scale