
1. Re: Hide ? on Layout When Dividing by Zero
David Moyer Sep 12, 2016 9:58 AM (in response to greengk2fi)1 of 1 people found this helpfulHi,
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).
Let(
den = GetSummary(the one in the denominator);
If ( den > 0 ;
the numerator / den ;
"" )
)

2. Re: Hide ? on Layout When Dividing by Zero
greengk2fi Sep 12, 2016 10:28 AM (in response to David Moyer)Thanks so much!

3. Re: Hide ? on Layout When Dividing by Zero
greengk2fi Sep 18, 2016 12:24 PM (in response to greengk2fi)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?