Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The goal is to create an expression that will calculate the average length of service per employee < 1yr of service. Below is a sample table and the syntax that I tried but is not working.
Any thoughts?
Syntax that is not working > =Sum({<[Length of Service]={'<=1'} >}[Length of Service])/Count(DISTINCT Emp_ID)
Emp_ID | Dept | Length of Tenure |
1 | Shipping | 0.2 |
2 | Packing | 5 |
3 | Cashier | 0.7 |
4 | Management | 0.4 |
Sum({<[Length of Service]={"<=1"} >}[Length of Service])/Count(DISTINCT Emp_ID)
Single quote represent a String. Can you try double quote?
Sum({<[Length of Service]={"<=1"} >}[Length of Service])/Count(DISTINCT Emp_ID)
Single quote represent a String. Can you try double quote?