G
gumby
I want to sum [Tuition Cost] but only if [Final Action] equals either
Approved, Pending, or Obligated. The control source below works fine. I
am just interested to find out if a easier way exists.
=Sum(Abs([Final Action]="Approved")*[Tuition Cost])+Sum(Abs([Final
Action]="Pending")*[Tuition Cost])+Sum(Abs([Final
Action]="Obligated")*[Tuition Cost])
Othe ways I have tried.
=Sum(Abs([Final Action]="Approved" And "Pending" And
"Obligated")*[Tuition Cost]
=Sum(Abs([Final Action]="Approved" And [Final Action]="Pending" And
[Final Action]="Obligated")*[Tuition Cost]
Thanks,
David
Approved, Pending, or Obligated. The control source below works fine. I
am just interested to find out if a easier way exists.
=Sum(Abs([Final Action]="Approved")*[Tuition Cost])+Sum(Abs([Final
Action]="Pending")*[Tuition Cost])+Sum(Abs([Final
Action]="Obligated")*[Tuition Cost])
Othe ways I have tried.
=Sum(Abs([Final Action]="Approved" And "Pending" And
"Obligated")*[Tuition Cost]
=Sum(Abs([Final Action]="Approved" And [Final Action]="Pending" And
[Final Action]="Obligated")*[Tuition Cost]
Thanks,
David