Dimension values are coming as " ? " (question mark) in sheets instead of number format

[Mapuna]

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?

[marcus_sommer]

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