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!

 

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, 201510 yr by Alex Lxj

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?

 

Why not a calculation field?

It's a CPU hog? It does not perform well on WAN deployments.

It's a CPU hog? It does not perform well on WAN deployments.

I said a calculation field, not an unstored calculation field.

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, 201510 yr by ggt667

Why not a calculation field?

My bad, I meant stored calculation

The formula seems to be working well. 

 

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 = "";0
would make more sense as you are working with numbers, or are you using "" as empty value?

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, 201510 yr by comment

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, 201510 yr by ggt667