Skip to Content
0

Calculation Context

Jul 25, 2017 at 10:56 AM

28

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jul 25, 2017 at 11:24 AM
0

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)

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thankyou Amit this answered my question.

Will

0