Jul 01 2021 05:47 AM
Not sure if this can be done i have this =SUM([@Total]/[@[Age Years]]) returning a #DIV/0! error as some of the age years are 0, is there an IF or IFERROR i can add some it returns the @Total figure?
Jul 01 2021 07:09 AM
Solution@AnnAPTL Not sure what you are trying to calculate, but try it like this:
=IFERROR([@Total]/[@[Age Years]],[@Total])
and you don't the SUM, byt the way.
Jul 01 2021 07:09 AM
Solution@AnnAPTL Not sure what you are trying to calculate, but try it like this:
=IFERROR([@Total]/[@[Age Years]],[@Total])
and you don't the SUM, byt the way.