9 Replies Latest reply: Feb 8, 2016 5:12 PM by Sébastien Fatoux RSS

    How to sum 2 fields in an IF statement

    John Jackson

      sum 2 fields.PNG

       

      If Environ is Internal, I want the avg of Score A, If env is External, I want Avg of ScoreB, If its both, I want the avg of

      scoreA and scoreB. how to write the IF statement as an expn in Straight Table.

       

      =if(Environment='INTERNAL ',avg({$< Enviornment={"INTERNAL"}>} ScoreA),

      if(Environment='EXTERNAL ', avg({$< Environment={'EXTERNAL'}>} ScoreB),

      avg(sum(.........))) I am stuck here, any help would be appreciated