Adding Rows that don't exist
Adding Rows that don't exist
(OP)
Hi,
I am working on a report and need to display additional rows that don't exist.
Eg.
Tenure 00-01 Headcount 15
Tenure 01-02 Headcount 20
Tenure 03-04 Headcount 10
Tenure 04-05 Headcount 5
In this example there is no one with Tenure 02-03, I want to display Tenure 02-03 and Headcount 0, instead of not displaying it at all.
I appreciate any help
Thanks
Floyd
I am working on a report and need to display additional rows that don't exist.
Eg.
Tenure 00-01 Headcount 15
Tenure 01-02 Headcount 20
Tenure 03-04 Headcount 10
Tenure 04-05 Headcount 5
In this example there is no one with Tenure 02-03, I want to display Tenure 02-03 and Headcount 0, instead of not displaying it at all.
I appreciate any help
Thanks
Floyd
RE: Adding Rows that don't exist
RE: Adding Rows that don't exist
RE: Adding Rows that don't exist
RE: Adding Rows that don't exist
There are some job levels that have headcount in each tenure while there are some that are missing headcount in some tenures. My goal is to display all tenures. Once i can display all tenures for each joblevel, then i have some furthur calculations. I will try Set all = on. Hopefully it works
Thanks
RE: Adding Rows that don't exist
CODE
IF TENURE FROM 1 TO 2 THEN 2 ELSE ...
You can code something like this:
CODE
1 AS 'Tenure 00-01 Headcount' OVER
2 AS 'Tenure 01-02 Headcount OVER ...
This use the FRL facility of the TABLE command.