I am trying to plot a graph…but firstly my figures are coming up incorrect. Iam using CRXI Rel2,
I have 2 groups…group 1 ‘Team’ and group 2 ‘employeenumber’.
Then I have a formula in place as a employeenumber can be part of one of two companies ie.
formula 1 = if companies = ‘a’ then 1 else 0
formula 2 = if companies = ‘b’ then 1 else 0
these formula’s at detail level…
The next thing I want to do is to sum the above per group 2 and insert into a graph.
However under gp 2, in the details line I have more than record so when I sum formula 1 or 2, the figures are
incorrect. I have tried various ways around this but no joy so far…anyone any ideas?
Details Line : Employeeid Company Wage %oftime subdept
1234 a 10 75 ac
1234 a 10 25 ac
5412 b 12 35 ab
5412 b 12 65 ab
I want to sum the number of employees per company, per Managerid in the graph. However as above, field %oftime is causing 2 records or sometimes more per employeeid.
I had put in formula’s
formula 1 = if companies = ‘a’ then 1 else 0
formula 2 = if companies = ‘b’ then 1 else 0
So that I can sum at GF2 and enter into graph, but this is giving me incorrect results.
(BOB member since 2009-07-30)