hourly rates

[the_furious]

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!

 

[Alex Lxj]

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

[comment]

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?

[ggt667]

 

Why not a calculation field?

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

[comment]

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

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

[ggt667]

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

[the_furious]

Why not a calculation field?

My bad, I meant stored calculation

The formula seems to be working well. 

 

[ggt667]

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?

[comment]

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

[ggt667]

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