Forum Discussion
Solved
help with formula
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?
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.
2 Replies
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.
Thank you Riny_van_Eekelen that worked
