Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Icon for Helper V rankHelper V
2 years ago

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...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

I don’t understand what you are dividing by what, where is the #DIV/0!,

  • NadeemAhamed's avatar
    NadeemAhamed
    Icon for Helper V rankHelper V
    2 years ago

    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