Joined: 18 Oct 2010
Location: United States
Online Status: Offline
Posts: 21
Topic: Cannot "finish" formula Posted: 17 Nov 2010 at 10:04am
Hi Everyone,
Cannot get this formula to work - what do I need to add to "close" it for lack of better word. It says there is an error when I try to use it. Here is what I have-
if {master_part1.WtMeterRateCode1}= "WT" then 5.00 or
if {master_part1.WtMeterRateCode1}= "WS" then 5.00 or
if {master_part1.WtMeterRateCode1}= "w1" then 26.25 or
if {master_part1.WtMeterRateCode1}= "w2" then 33.50 or
if {master_part1.WtMeterRateCode1}= "w3" then 38.00 or
if {master_part1.WtMeterRateCode1}= "w4" then 51.00 or
if {master_part1.WtMeterRateCode1}= "w6" then 87.50 or
if {master_part1.WtMeterRateCode1}= "w7" then 116.50 or
if {master_part1.WtMeterRateCode1}= "w8" then 145.74 or
if {master_part1.WtMeterRateCode1}= "w9" then 229.00
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 17 Nov 2010 at 10:15am
replace all of your ORs with ELSE...
if {master_part1.WtMeterRateCode1}= "WT" then 5.00 ELSE if {master_part1.WtMeterRateCode1}= "WS" then 5.00 ELSE if {master_part1.WtMeterRateCode1}= "w1" then 26.25 ELSE...
if none of the conditions are met it will return zero
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
