0

#Value! Error when click check Error data is display .

Thatsama

June 10, 2022 02:37

None

Follow

#Value! Error when click check Error data is display 

Please help me how to solve it

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Marc June 13, 2022 09:43

  #VALUE! typically means the formula is wrong. But it'll not be possible to diagnose any further without looking at it. Can you copy the formula bar into this chat and we can take a look?

• 0
  
  CascadiaDataworks June 14, 2022 23:13

  If you are clicking Check Error with a #VALUE and it is then showing the value, this usually signifies that the connection is timing out at some point in the report run.  When you then click on Check Error, it pings the database to find the error but finds the answer instead.  Consider extending the timeout setting in the Settings, usually starting at double the initial setting.  

  Sometimes the timeout has to do with inefficient reports but that would ultimately require a consultant reviewing the entire report looking for inefficiencies. 

• 0
  
  Thatsama June 15, 2022 01:27

  I already fixed. Using @@ in the formulas

  Thank you everyone.

• 0
  
  CascadiaDataworks June 15, 2022 16:35

  Glad to hear it is resolved.  In the future, best thing when you are getting #VALUE is to use the Check Error button. If you are getting an error, it is best to provide the error message here and a copy of your function where the error is happening.