Number in Data Editor inconsistent with layout display

Ask for Help
1

Hi there,

I have a scenario where i am using Big Numbers to display my rollup column.

Long story short, to count the number of users who have Added my event to their calendar, set column values to ‘Yes’. My rollup column would count the number of ‘Yes’. It is not a user-specific column.

In Data Editor as well as in the dropdown list, it is shown as ‘2’, in images:

Dropdown selection:
image

Data editor,
image

However, in ‘Data’ display (the button on bottom left), it’s shown as ‘0’
image

As well as the displayed value in my Big Numbers component:
image

Why would the same value/column display differently/incorrectly? How do i fix this?

Thank you

2

The most likely cause of this is that you have Row Owners applied somewhere.

3

Thanks for the quick help.

Nope there isnt a row owner in this sheet, it’s the user login sheet actually.
My profile can see all rows (not greyed out).

4

adding on, i face the same issue even when the info is on another sheet.

5

I would still suspect Row Owners. Sometimes the effect is not obvious in the builder.
I would check every table and column that feeds into the rollup. Trace it all the way back until you hit a non-computed column.

6

Still no luck… I have manually went through every column and none are Row Owners-enabled.

Strangely, another column (CountNo.PushAllowed) is working and displaying fine:

Data editor:
image

Displayed:
image

7

Okay, so what is different about those two columns?
Do they both refer to the same table/s?

By the way, the best way to absolutely eliminate row owners as the cause is to remove them and see if anything changes.

8

They are both rollup columns.

CountNo.PushAllowed is a rollup derived from user login table (without row owners)

CountNo.AddedToCalendar is a rollup derived from another table (with row owners)

You are right, the underlying table has row owners. I removed it and it works perfectly… however i need to keep the row owner due to functionality purposes.

Guess i will find another way around this… thanks for your help

9

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.