Custom field or report method- best way around this?
Posted: Tue Jan 09, 2018 4:40 pm
I have a Custom field that returns a percent impurity by multiplying area by RRF. My answer needs to be in the range of 0.5 to 1.0%. I created a Boolean CF along the lines of GTE(Percent_Imp, CConst3)+LT(Percent_Imp,CConst4) (Peak, Real, Calculated) and plugged my upper and lower ranges into CConst3,4 but I get nothing back, I cant get my head around what I'm doing wrong. If Empower allowed the formula when I created it, surely its valid/possible?
Then I thought my report method would work, cant I just throw my CF into the table and apply a Min/Max to this? Or I could even apply a Limit to this CF in the proc method which would fault the value outside of the range. I'm still curious as to why the Boolean wouldn't work, I checked the CConst3/4- they are populated, I have the value set to Use as Text and don't have all or nothing ticked.
Thoughts?
Then I thought my report method would work, cant I just throw my CF into the table and apply a Min/Max to this? Or I could even apply a Limit to this CF in the proc method which would fault the value outside of the range. I'm still curious as to why the Boolean wouldn't work, I checked the CConst3/4- they are populated, I have the value set to Use as Text and don't have all or nothing ticked.
Thoughts?