How to subtract a field value and place in another

[corey]

Case(Width="750" and thickness="2" and Type="COLD" and Site="OnSite" and NormalorOT="ot", "7")

With the above NUMBER CAL. depending on the chosen values for the [Width], [thickness], [type], [site] and [normalorot] FIELDS it returns a NUMBER Value.

BUT what i want to do is IF that NUMBER is OVER "2",{IN THIS CASE IT IS 7} then i want the amount >(greater) than "2" {5}to be input into another field.

Can i have 2 x STRINGS within this CALCULATION Field?, or how do i go about having the amount over "2", to be input into another field??

IS IT A if(FIELD) OR :

Any help would be appreciated.

Regards

Corey...

[cjaeger]

How about

Case(Width="750" and thickness="2" and Type="COLD" and Site="OnSite" and NormalorOT="ot", 7- thickness)

[corey]

Thnx for the reply, BUT the [thickness] value is not always the SAME value as 2.

i need to have something similar but if in the stated case the resukt is 7, then 2 is left in that field, and the leftover (5) is placed into ANOTHER field specified.

E.G

If the CAL result is 10.

Then i need 2 to be left in the field, and the remaining 8 to be placed in ANOTHER designated field{double}.

Thnx.

Looking 4ward to a reply....

[cjaeger]

you could script that. but probably don't have to.

do you have to include th AND thickness, i.e. are there other thickness valuse for Width="750" AND Type="COLD" etc?

To put values in other fields, just set them to a similar if same calc, including an empty result if condition is not met.

leftover1=if(your long expression from above = 7,7,"")