the_furious Posted October 30, 2015 Share Posted October 30, 2015 Hi everyone, I have a field for for hourly rates, price per unit is $100, however, subsequent hours are half of the original unit price ($50) I need a auto calculation that reflects the actual amount, based on the number of hours inputted. (e.g. 5 hours = $300) I'm raking my brains on how to perform such calculations. Anyone can shed some light to me? Appreciate it! Link to comment Share on other sites More sharing options...
Alex Lxj Posted October 30, 2015 Share Posted October 30, 2015 (edited) Case ( time>1 ; ((time-1)*50)+100 ; time<1; time*100 ;time=1; 100;time = "";"") something like that? make field "time" and calculated "price", un-tick don't replace... Edited October 30, 2015 by Alex Lxj 1 Link to comment Share on other sites More sharing options...
comment Posted October 30, 2015 Share Posted October 30, 2015 I have a field for for hourly rates, price per unit is $100 Rates change as time goes by, so hopefully you do have a field for HourlyRate that looks up the current rate. Then you can calculate the amount as = 0.5 * HourlyRate * ( HoursWorked + Min ( HoursWorked ; 1 ) ) I need a auto calculation Why not a calculation field? Link to comment Share on other sites More sharing options...
ggt667 Posted October 30, 2015 Share Posted October 30, 2015 Why not a calculation field? It's a CPU hog? It does not perform well on WAN deployments. Link to comment Share on other sites More sharing options...
comment Posted October 30, 2015 Share Posted October 30, 2015 It's a CPU hog? It does not perform well on WAN deployments. I said a calculation field, not an unstored calculation field. Link to comment Share on other sites More sharing options...
ggt667 Posted October 30, 2015 Share Posted October 30, 2015 (edited) Calculation fields are still a drag in FileMaker 11 for WAN delpoyments; may or may not be better in latest version of FileMaker. Do you run WireShark on your solutions to test bandwidth distribution? Edited October 30, 2015 by ggt667 Link to comment Share on other sites More sharing options...
the_furious Posted October 30, 2015 Author Share Posted October 30, 2015 Why not a calculation field? My bad, I meant stored calculation The formula seems to be working well. Link to comment Share on other sites More sharing options...
ggt667 Posted October 30, 2015 Share Posted October 30, 2015 Case( time > 1; ( ( time - 1 ) * 50 ) + 100 ; time < 1; time * 100 ; time = 1; 100; time = "";"") This piece made me a bit curious: time = "";""I'd believe time = "";0would make more sense as you are working with numbers, or are you using "" as empty value? Link to comment Share on other sites More sharing options...
comment Posted October 30, 2015 Share Posted October 30, 2015 (edited) Calculation fields are still a drag in FileMaker 11 for WAN delpoyments; If you are observing any difference in performance between a stored calculation field and a Text/Number field with auto-entered calculated value, then either your observation is wrong, or you have news that belong on the front page, not in a footnote to this question. Edited October 30, 2015 by comment 2 Link to comment Share on other sites More sharing options...
ggt667 Posted October 31, 2015 Share Posted October 31, 2015 (edited) If you are observing any difference in performance between a stored calculation field and a Text/Number field with auto-entered calculated value, then either your observation is wrong, or you have news that belong on the front page, not in a footnote to this question. Do you run WireShark on your WAN deployments to test bandwidth distribution? Edited October 31, 2015 by ggt667 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3094 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