1 of 1 people found this helpful
the Hide Object condition would be
Not GetSummary(the one in the denominator)
p.s. you can make this more efficient by changing your calculation to use the Let statement and the "" (empty string).
den = GetSummary(the one in the denominator);
If ( den > 0 ;
the numerator / den ;
Thanks so much!
Thanks again for your previous help. That did work wonderfully for most of my report. However, I've got an issue where a the calculation in a contributing field can come up as incalculable. So when it is used in the next calculation, it reports ? I've tried a few things but can't seem to get it going.
For example, the growth of average $ per service causes this issue. If there hasn't been a sale of that item in the previous year, then the calc for for that year's $ per service will come up with an issue due to dividing by zero. When this calculation is used as part of the difference between two years, obviously it returns ? but not because of the previous denominator. So I'm back to wondering if there is an "incalculable" calculation that would allow me to hide the field when a cal field is incalculable. Any other ideas?