I have a report where BWTID is grouped. I have the summary total in the footer for EMPDH (employee hours). I am trying to create a summary list of each bwtid and the total hours for that btwid.
I tried this and it worked beautifully for the first one:
=IIf([bwtid]=2,[Text26],0)
but failed and returned a zero when i changed the btwid to 4.
so i tried this:
=Sum(IIf([bwtid]=4,[empdh],0))
and i get #ERROR ... the correct answer here should be 11 ! see below :
What am i missing ?
Thank you !
I tried this and it worked beautifully for the first one:
=IIf([bwtid]=2,[Text26],0)
but failed and returned a zero when i changed the btwid to 4.
so i tried this:
=Sum(IIf([bwtid]=4,[empdh],0))
and i get #ERROR ... the correct answer here should be 11 ! see below :
What am i missing ?
Thank you !