Gold Customer
Joined: 12/24/2004 Posts: 33
|
IIF(stoc10. 4. 1 < avg(stoc10. 4. 1. 4) and stoc10. 4 > avg(stoc10. 4. 4) , .995 * min(l, 5), 0)
This formula shows error in formula, a missing period argument at position 39 (just before the 'and'), I cant figure it out, someone please point out my silly mistake!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
The mistakes are some extra spaces in your formula and slight mixups as to where to use commas versus periods.
IIF(STOC10.4.1 < AVG(STOC10.4.1, 4) AND STOC10.4 > AVG(STOC10.4, 4), .995 * MIN(L, 5), 0)
You could shorten this somewhat to the following.
IIF(XUP(STOC10.4, AVG(STOC10.4, 4)), .995 * MINL5, 0)
-Bruce Personal Criteria Formulas TC2000 Support Articles
|
Gold Customer
Joined: 12/24/2004 Posts: 33
|
excellent, thank you!
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
You're welcome.
-Bruce Personal Criteria Formulas TC2000 Support Articles
|