help with calculation

[alexo229]

I having a little problem with the following calculation:

If (Quantity 4 ≤ 275 ; 2.25 ; ( Quantity 4*.00823) )

See, if "Quantity 4" is more than 999, then it defaults to 2.25!???

I want to be able to enter more than 999.

TIA

Alex

[Maarten Witberg]

I could reproduce this problem when "Quantity 4" was defined as text field.

 

kjoe

[Ted S]

I'm making a guess here but could the fields involved be classified as TEXT rather than NUMBER?

[alexo229]

Thanks for the response kjoe and Ted S.

Yes it's defined as a text field.

Do I need to change it? To what?

Thanks

[Robert Schaub]

I having a little problem with the following calculation:

If (Quantity 4 ≤ 275 ; 2.25 ; ( Quantity 4*.00823) )

See, if "Quantity 4" is more than 999, then it defaults to 2.25!???

I want to be able to enter more than 999.

TIA

Alex

 

 

Case( Quantity 4 ≤ 275; 2.25;

Quantity 4 > 275, Quantity 4*.00823;"")

[Maarten Witberg]

it should be Number field. Alternatively, if it really must be a text field for any reason, change the calc to

 

If ( GetAsNumber(Quantity 4) ≤ 275 ; 2,25 ; ( GetAsNumber( Quantity 4) *,00823) )

 

I'd use number field if at all possible.

 

kjoe

[alexo229]

It's ALIVE!!!

T H A N K Y O U ! All of you.

It's almost Friday!!

Have a nice weekend!!