Expand my Community achievements bar.

Join us for the next Community Q&A Coffee Break on Tuesday April 23, 2024 with Eric Matisoff, Principal Evangelist, Analytics & Data Science, who will join us to discuss all the big news and announcements from Summit 2024!
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