Quote:
Originally Posted by macropod
Did you use Ctrl-F9 for all the field braces (i.e. { }) - you can't simply type them or copy & paste them from this forum. Also, the spaces indicated in the code I posted are all essential.
|
Yes, that was one of my first mistakes earlier today when I was trying to figure out how to do the simpler formulas. Getting the nested fields was an initial issue, but I was using Ctrl-F9 when I tested the updated formula. It's perhaps the 'IF' clause I was doing incorrectly. I will experiment with just that on Monday to see if I was entering it wrong.
And, now the client has done another 180, and decided to reinsert the calculations, so it's back to being a necessity. I swear, they act more like politicians than clients sometimes.
I appreciate your assistance on this.