by
DR » Tue Jul 21, 2020 8:49 pm
Apologies for bumping a 9 year old thread, but it addresses a fn I'm a little confused about.
What I want: Purity factors in the component table to default to 100 if no value is entered.
What I have: Purity, a peak, real (0.0) CF with no default whose formula is REPLACE([Purity (Component)],100)
What it does: replaces even entered component purity values with 100 on review of result sets
Any suggestion?
Also not working:
LTE(REPLACE([Purity (Component)],0)*100)+GT(REPLACE([Purity (Component)],0)*([Purity (Component)])
My thought is that if Purity for a component is 0 or blank, it should be replaced with 100, and if it's >0, it is replaced with itself, but I'm either sort an argument or have too many braces or parentheses when I try to enter the above.