I am displaying some roll up financial data in a tab. Just a Value in a text box.
It is showing a different value when a user looks at it on their browser. When I look in Glide ‘as them’ it shows the correct value. When I look in the (Glide) database, again the correct value. But the user is still seeing the incorrect value.
Any ideas on how to troubleshoot this…
Are you trying to Rollup values under row ownership? If they don’t own the rows that are being rolled up, then they won’t have access to that unowned data.
It’s not row ownership - it is ‘their’ number - it’s just calculating it incorrectly on the web browser.
Basically, I have Value A - it is a very complex calculation and one of the variables is Value B
I need to show Value A and Value B in the same panel - however I don’t want Value A to change when Value B changes so I have synthesised Value C which is effectively the same calcs for Value A but without Value B. This means that when Value B changes from the default of Zero, Value C will always be Value A without the impact of Value B.
The trouble I have is Value C is being calculated and displayed differently on different devices… the ‘correct value’ is always shown correctly on Glide when I look as the user, and in Value C is shown as the correct value in the Glide DB in the column that UI references. On someone elses device, it shows a different number. Quite bizarrely it looks like it is double counting one of the factors I synthesize in Value C
It feels like a bug - almost like the calcs on the device are being done differently.
There is a workaround to how I display the values, but I’m worried about the discrepancy that I can see - is this happening somewhere else in what is a complex financial model, that I can’t pick up?
Without knowing anything about your calculations, it’s hard to say where it’s going wrong. Are dates involved at any point in your calculations?
Dates (years) are used a little bit - it was an area I’ve been looking at…
Something with dates would be my best guess. Dates are formatted based in the user’s device settings, and the built in date formatting columns can sometimes misinterpret them (mixing up month and day for example).
thanks - I’ll pursue that. I can easily surface ‘what is today’s date?’ to a screen… (although - date of birth is a prime value I collect) - we shall see - thank you!!!