Skip to Content

Calculation Context

Hi

I need to be able to show data at a particular level (in my report this is known as Level3:Structure)

I have attached a file which shows on the left hand side how the Bus Obj report looks before any calculations are added. I want to be able to create a report similar to the one on the right hand side of the file which will show a count of anyone who has 3 or more absence counts. Can anyone help me with writing the variables to acheive this?

Thanks

Will

calc-context.png (31.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 25, 2017 at 11:24 AM

    assuming your count object is like.

    count=Count([Personal ID];All)

    use this in right table.

    =Sum(If([count] ForEach ([Personal ID]) >=3) Then 1 Else 0)

    Add comment
    10|10000 characters needed characters exceeded