Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attended or Not | non-attendance 200 150 300July | Now I am only able to display the attendance in 1 graph and the non attendance in another graph as the expression says error when I try to do SUM (attendance) SUM (non-attendance).August | Can anyone assist with this? - ThanksSeptember |
Non-Attendance | 4960 | 5944 | 4347 |
Attendance | 21759 | 27846 | 11711 |
hi
see the attached file
Hi
use 2 expr
1st expr
if(
Attended
or Not
='Attendance',sum(july)+sum(august)+sum(september),Null())
2nd exp
if(
Attended
or Not
='Non-Attendance',sum(july)+sum(august)+sum(september),Null())
Thanks, however I cannot open the file as I am using the personal edition. Please can you send me the expression
Thanks, but it says "Bad expression"
Hi
can u give ur expressions
im using some sample data its work
plz see that image
it display empno=1 sum in one bar and 2 in another bar same like ur
ateendend, not-attend
I think it does not find Attendance and Non-Attendance
Thanks, I have sorted it out.