Creating a calculation in revelation reporter using calculated fields. (Reporter Specific)
At 21 JUL 1998 04:49:36PM Kevin Margeson wrote:
I need what would seem is a simple report. It is a PM Compliance Report. It needs to compare the amount of work orders opened -vs- the amount closed. Tricky part: The report must have a double group: first by Department then by Trade. We need a percentage for each trade inside a department then a percentage for the entire department. Formula: (ClosedWo's / TotalWo's) * 100=MyPercentage. Simple Right?. Here is how I tried to create the report but had no luck. I created 2 symbolic fields in the dictionary, one called Total and one called closed. There script said "IF {WO_NO} NE '' THEN @ANS=1" (this will give me a total count of all work orders and "IF {STATUS}=CL" THEN @ANS=1" (This gives me a total of the work orders closed. If you were looking at the report it would show a 1 if the work order was closed and a 0 meant that it is still opened. All the above works great except how do I get my percentage ? I can sum both total and closed and get a correct answere but I can not use those 'SUMS
' for any other calculation.
At 22 JUL 1998 01:09PM Andy Gilman wrote:
As far as I can tell there is no way to create a calculation based on total fields. Take a look at the thread I started June 24.
Wish I had better news for you.