Total Cost

[glenhest53]

I have a field "Total Cost" which is a calculation from 2 other fields

Photo Cost + Copy Cost.

I now need to perform a calculation if a radio button from a field "Discount" is checked. If this radio button is checked then I need the "Total Cost" field to be reduced by 50%.

Thanks in advance

Dave

[aklodner]

Try this out, make Total Cost calculation as follows:

(photo cost + copy cost) - Case(discount = "yes", (photo cost + copy cost)*.5, 0)

HTH,

Adam

[Fitch]

Same basic idea:

(photo cost + copy cost) * Case(discount = "yes", .5, 1 )

or this:

(photo cost + copy cost) / Case(discount = "yes", 2, 1 )

Note that if your discount field has a value list of "1" or "2" or ".5" (not all three choices, I mean one or the other of those as the whole list, and use a checkbox, not a radio button) you could make it even simpler. Also you'll probably want to enclose the whole thing in a Round() function.

[-Queue-]

(PhotoCost + CopyCost) * Case( Discount = "yes", 0.5, 1 ) would be faster.

[-Queue-]

You beat me this time, ya bugger.

[glenhest53]

Thanks Guys:

I also have a Payment Info field that indicate various payment options (radio buttons) plus an option "Make Good".

If this "Make Good" option is selected then Photo Cost and Copy Cost should be set to 0. Even if there is a Photo size selected and Ad copy has text.

Photo Cost field gets its value from the Photo Size field i.e.

If(Photo Size =

[-Queue-]

Case( PatternCount( Payment, "make good" ), 0, Case( Photo Size =

[glenhest53]

Thanks Queue:

Time for me to do some more reading on Functions and Calculations.

Dave