solutions wanted Calculation field

[Tom Henvey]

Where I live there is a 1% city tax on purchases but limited to a $25 maximum. I want to create a calculation field that will be:

Total$ * .01 (but if greater than $25, then enter $25). I'm sure this is basic to most of you, but I'm a beginner. Thanks for the help. -th

[comment]

How about Max ( Total * 0.1 ; 25 )?

BTW, using a $ symbol in a field name is not recommended - see Help > Creating a database > Defining database fields > About naming fields.

[Tom Henvey]

That was quick. Thanks for the tip on using $ in field names. I used the script you suggested: Max ( Price * .1 ; 25 ) but it is giving 1% of the price with no limit. -th

[Ender]

Since you're talking about 1%, wouldn't that calc be:

Max ( Price * .01 ; 25)

[Tom Henvey]

You are right about the .01 (see my initial post) but it is still not limiting the calculation to a maximum of 25. -th

[comment]

Sorry - a typo AND a mental lapse. Try:

Min ( Price * .01 ; 25)

[Tom Henvey]

Thank you. The Max to Min worked like a charm. Thanks again. -th

[David McQueen]

You can also use a case statement

Case( Price*.01>25;25;Price*.01)

[Tom Henvey]

Thanks. This forum is great.

I am learning. -th