Expand my Community achievements bar.

Announcement: Calling all learners and mentors! Applications are now open for the Adobe Analytics 2024 Mentorship Program! Come learn from the best to prepare for an official certification in Adobe Analytics.
SOLVED

What's (#NUM!) in Bounce rate & Exit Rate?

Avatar

Level 1

Hi Team,

Could you please guide me for the below-mentioned concern. What is the meaning of special character data (#NUM!) signification in Bounce rate & Exit Rate calculation. is it equal to 0.00% or data error?

Thanks & Regards,

Ajay Tiwari

1 Accepted Solution

Avatar

Correct answer by
Level 5

Hi Ajay,

Is it Excel shows this error when a formula or function contains numeric values that aren't valid. (If your Data block had reference to formula)

Reference error This often happens when you’ve entered a numeric value using a data type or a number format that’s not supported in the argument section of the formula.

Check on below link for solution

https://exceljet.net/formula/how-to-fix-the-num-error

Thanks,

Balaji

View solution in original post

1 Reply

Avatar

Correct answer by
Level 5

Hi Ajay,

Is it Excel shows this error when a formula or function contains numeric values that aren't valid. (If your Data block had reference to formula)

Reference error This often happens when you’ve entered a numeric value using a data type or a number format that’s not supported in the argument section of the formula.

Check on below link for solution

https://exceljet.net/formula/how-to-fix-the-num-error

Thanks,

Balaji