Forum Discussion
Avoiding #DIV/0! (inf) for calculated values
Dear All, Greetings! I have calculated measures which is perform division for two physical column from excel sheet. We have some formula=IFERROR(A1/B1,0) in excel to avoid this #DIV/0! or inf...
I don’t understand what you are dividing by what, where is the #DIV/0!,
In my actual data we have this error.
what i have shared that is sample data.
i want to apply formula for this variance and achievement measures