AnsweredAssumed Answered

Calculation ignoring text

Question asked by tays01s on Sep 10, 2018
Latest reply on Sep 11, 2018 by tays01s

In the following calculation:

Case(

Nut_calcs::Std_EN = "No Std"; "No Std";

Round(Nut_calcs::aim_e*100/Nut_calcs::Std_EN;0)

)

+

Case(

Nut_calcs::Std_PN = "No Std"; "No Std";

Round(Nut_calcs::aim_p*100/Nut_calcs::Std_PN;0)

)

IF either of the Std's does = "No Std", it doesn't return "No Std", it just ignores it. No difference if I encapsulate the whole calc within Evaluate(Calc). NB. All the source and results fields are 'text'.

 

I'd be interested in the 'rule' governing this?

Outcomes