river bend Posted September 25, 2013 Posted September 25, 2013 I have 4 fields defined as miles, rate, gross_amount, volume_amount and flat_rate. The gross_amount field needs to calculate this scenario: if miles has a value then miles * rate if flat_rate has a value then flat_rate if neither has a value then volume_amount (which is a calculation field) needs to return volume_amount * rate. I have tried different scenarios but not able to make it work. Case ( IsValid ( flat_rate ) ; flat_rate ; IsEmpty ( flat_rate ) ; (miles * rate) ; volume_amount * rate )
Fitch Posted September 25, 2013 Posted September 25, 2013 Case ( not IsEmpty( miles ) ; miles * rate ; not IsEmpty( flat_rate ) ; flat_rate ; volume_amount * rate ) 1
Recommended Posts
This topic is 4134 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now