Calculation gives the wrong result on some records


1 comment

  • Susan Warren-Moy

    Ah - OK. I was missing the check that activity == work placement from the IF statement. It should read

    if ((emp[i] == @All of Employer) && (act[i] == "Work Placement")) 

    This is now rectified, and all except one record is correct.

    I still can't work out why the one record has the wrong figure, though!

    Timetable is filtered to Student [name], Activity = Work Placement, Employer = [her employer] - and the total number of Planned hours does not match the report app.

    However, it is only 1 student so it's likely to be something in her records rather than an error in the coding, so I will do some digging and find it.

    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk