M
MacNut2004
Hello,
I am having trouble doing calculations in a report that is based on a
crosstab. I want to do a calculation that is a billable percent -- so that
is the project time/total time. Well, in a crosstab, you never know which
field is going to be "project time" when it's in no particular order in the
query. I have a table of column aliases used for these categories that looks
like this:
Alias Category
A Admin
B Project Bill
C PTO
D Training
At one point, another category can be used that would go between "admin" and
"project bill" forcing project bill to be alias "C" in this case. So on the
report, how am I supposed to do a billable percent calculation based on this
uncertainty?
Thank you!
MN
I am having trouble doing calculations in a report that is based on a
crosstab. I want to do a calculation that is a billable percent -- so that
is the project time/total time. Well, in a crosstab, you never know which
field is going to be "project time" when it's in no particular order in the
query. I have a table of column aliases used for these categories that looks
like this:
Alias Category
A Admin
B Project Bill
C PTO
D Training
At one point, another category can be used that would go between "admin" and
"project bill" forcing project bill to be alias "C" in this case. So on the
report, how am I supposed to do a billable percent calculation based on this
uncertainty?
Thank you!
MN