Crystal XI. Have these fields/formulas to calculate the number of rooms required for a building with a particular capacity:
CAPACITY
@MaxCapacity = CAPACITY * 0.95
@Rooms = @MaxCapacity / 15
@TotalArea = @Rooms * 60
And Group sum totals for each placed in the Group Footer.
...which all seems pretty simple and the values returned are accurate. For one group summary, for example, these results are returned:
CAPACITY = 35
@MaxCapacity = 33 (displayed rounding)
@Rooms = 2.22
@TotalArea = 133.00
But I don't want partial rooms. In other words, @Rooms = 2.22 should calculate to 120, not 133. I can display round the @Rooms just fine, but I want @TotalArea to reflect an even multiple of 60 square feet; so I assumed using the ROUND() function should do the trick:
@TotalArea = round(@Rooms) * 60
...should round @Rooms to 2 * 60 = 120
But it simply changes @TotalArea in both the Details and Summary to zero. In fact, it doesn't seem to matter where I try to use ROUND() in any formula, it changes the results to zero in both the details and group sums.
Why?
Merle
CAPACITY
@MaxCapacity = CAPACITY * 0.95
@Rooms = @MaxCapacity / 15
@TotalArea = @Rooms * 60
And Group sum totals for each placed in the Group Footer.
...which all seems pretty simple and the values returned are accurate. For one group summary, for example, these results are returned:
CAPACITY = 35
@MaxCapacity = 33 (displayed rounding)
@Rooms = 2.22
@TotalArea = 133.00
But I don't want partial rooms. In other words, @Rooms = 2.22 should calculate to 120, not 133. I can display round the @Rooms just fine, but I want @TotalArea to reflect an even multiple of 60 square feet; so I assumed using the ROUND() function should do the trick:
@TotalArea = round(@Rooms) * 60
...should round @Rooms to 2 * 60 = 120
But it simply changes @TotalArea in both the Details and Summary to zero. In fact, it doesn't seem to matter where I try to use ROUND() in any formula, it changes the results to zero in both the details and group sums.
Why?
Merle