SOLVED

help with formula

Copper Contributor

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?

2 Replies
best response confirmed by allyreckerman (Microsoft)
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.

Thank you @Riny_van_Eekelen that worked

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
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.

View solution in original post