
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dimension values are coming as " ? " (question mark) in sheets instead of number format
Hello experts,
The above code has text format in table b. num#() is used on that dimension by taking resident in table c. I am getting the below output in sheets:
However if i use num#() in table b itself i get the values in number format as desired:
The result:
So the question is, why is num#() function returning " ? "(question marks) when the same dimension is used in another table by taking resident of the original table?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The question mark is applied if there isn't a string-representation of the values available because only these string-representations are shown in any objects. This could occur by converting-functions like num#() or field-functions like fieldvalue() if no further processing on these fields happens. This regards only to the visibility of the values and not to their exists - means the values are there and if any calculations with them executed they will work.
To avoid any confusion just wrap such measures with a text() or num().
- Marcus
