Hi
I have made a crosstab and I want to know how to make a calculation between 2 Totals (2 different levels).
I have something like this :
Ciclo 1 Ciclo2
Total 152 128
Ejecutado Total 108 64
Blocked 39
Error 31 1
Inprogress 1
Passed 38 62
No Ejecutado Total 44 64
44 64
I want to calculate "Total 152/Ejecutado Total 108"
Hi
I have a Cross Tab that looks like this :
| Date1 | Date2 |
-------------------------------------------------------------
Planned | 4 | 5 |
-------------------------------------------------------------
Executed | 3 | 5 |
-------------------------------------------------------------
% | 75% | 100% |
-------------------------------------------------------------
Passed | 2 | 4 |
-------------------------------------------------------------
Fail | | | 1 |
How can I do a calculation like : Executed/Planned and Executed/Planned .
Can this be done?
Could try putting in a footer and unlocking the report, then add into the footer something along the lines of:
total([Executed] for [Date]) / total(Planned] for [Date])
total([Name] for [Category]) / total ([Name])
There appeared to be two virtually identical posts asking the same question here, so I have merged them into a single thread. Please do not double-post questions.
MF.