This really isn't making much sense. Your latest attachment, just like you previous one, shows the $12.00 immediately before the 'piece/set' dropdown formfield being derived from whatever is in the PromoCost formfield. Using your own structure, I've given you a formfield that similarly employs whatever is in the PromoCost formfield but adds the functionality to divide that value by 4 when the 'piece/set' dropdown formfield's result is 'piece'. Are you now saying you want to use a value other than what is in the PromoCost formfield for the input?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|