Jump to content
Salesforce and other SMB Solutions are coming soon. ×

help with calculation


alexo229
 Share

Recommended Posts

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

Link to comment
Share on other sites

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;"")

Link to comment
Share on other sites

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

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use