Default Peak and varying a custom field formula
I have a peak enum custom field set to use as field and the formula is:
ENUM(LT(Area,CCalRef1[CConst1]),GTE(Area,CCalRef1[CConst1])) 0 is set to “Below Limit” and 1 is set to Area (fc)
I have 4 known peaks – API and API Imp 1, API Imp 2 and API Imp 3. I set API as my default peaks and set a curve ref of API against my 3 impurities. This works fine for all my knowns and unknowns, but I need to change the CConst1 value for only API Imp 1 from 10000 (In CConst1) to 20000. But when I put 20000 in CConst1 of API Imp 1 it still calculates using the CConst1 of API, no doubt because the formula is pointing it to “CCalRef1[CConst1]” but if I take out the CCalRef1 then I get nothing for my unknowns.
I tried changing it to CCompRef1[CConst1] but that only gave 1 result for the API which has CCompRef against the default peak..
I would rather not make a second CF to account for this one API Impurity that has a different limit, is there any way around this do you know?