Hour Report, can you divide two calculations?

[ajdifonzo]

I’m working in an Hour report and have two calculated columns, one for “Billable Hours” as follows

aggregator.displayformat=doubleAsDouble

aggregator.function=SUM

aggregator.namekey=hour.plural

aggregator.valueexpression=IF({hourType}.{countAsRevenue}=true,{hours},"")

aggregator.valueformat=doubleAsDouble

displayname=Billable Hours

textmode=true

valueexpression=IF({hourType}.{countAsRevenue}=true,{hours},"")

valueformat=doubleAsDouble

The other is “Total Hours (Less X40 & PTO)

aggregator.displayformat=doubleAsDouble

aggregator.function=SUM

aggregator.namekey=hour.plural

aggregator.valueexpression=SUB({hours},IF({hourType}.{name}="MCS - X40",{hours},IF({hourType}.{name}="MCS - Paid Time Off",{hours},"")))

aggregator.valueformat=doubleAsDouble

displayname=Total Hours (Less X40 & PTO)

textmode=true

valueexpression=SUB({hours},IF({hourType}.{name}="MCS - X40",{hours},IF({hourType}.{name}="MCS - Paid Time Off",{hours},"")))

valueformat=doubleAsDouble

I would like another column that will divide “Billable Hours” by “Total Hours (Less X40 & PTO)”

[skyehansen]

You would not be able to refer to the two column's results, but I don't see any reason why you would not be able to just copy and paste the two valueexpressions into a third one. The syntax for division is 

DIV(number1, number2, ...)

so I would just picture some sort of monstrous valueexpression=DIV((valueexpression1),(valueexpression2))

Give it a shot. Just watch your parens, and have a good time.