To return the minimum value:
Min ( field1 ; field2 ; field3 ....)
Min ($Pram1 ; $Param2 ; $Parm3....)
Min (repeatingField )
Min ( $Repeatingvariable )
If the values are in different records, you can also use a summary field with the minimum option.
do you know if it is possible to set the calculator to choose field3 between parameter 3 or 4 decided by the result of another parameter. so that is only 3 or 4 that is in the equation
Are these "parameters" fields in the same record?
There are any number of calculations using IF or Case you might set up depending on what you mean by "decided by the result of another parameter".
yes they are.
im looking on how much the blood is saturated with oxygen. but the there are different thresholds if the patient where recieving oxygen on a mask or not.
if the sat is <95% and the patient got oxygen on a mask it scores 2. but if he did not get oxygen he would get 3.
i have one field that say "no oxygen" =1 or "with oxygen" =2, lets call this field c
i have made a calculation that scores 1-4 wiht oxygen thresholds and whitout oxygen thresholds. lets call with o2 "a" and without o2 "b"
I want to have a calculation that choose between a or b. so that if c=1 the field shows the result from b or if c=2 the field shows the result from a.
then i can put my choose calculation into my min calculation.
If ( c = 1 ; b ; a )
Case ( c = 1 ; b ;
c = 2 ; a ;