Skip to main content
Question

Data refresh

  • February 17, 2021
  • 0 replies
  • 31 views
I am having an issue where if and I user look at the same data, we see different values.

So, if user NC looks at the report or table he sees -7930.65 as the current commission, but when I look at the table and reports I see the commission is 95.36.  If I test as user NC, I also see -7930.65.   So, literally I am looking at a summary report and the value changes based upon whether he is looking at it or I am looking at it.

No part of the mathematical calculation depends on the user.  I have been working on the data for most of the day.  I thought that refreshes would populate automatically to all users.  Is there a delay or something that I need to do to make sure that all users are seeing the most recent data? Other suggestions?

RESOLVED - permission issue - see below -thanks!
------------------------------
Karen Smith
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+14
If it's a summary report, can you see the records it is summarizing? Whichever records are missing on one of the two views should help troubleshoot.

It would seem to me that somewhere down the line (perhaps you are using lookup or otherwise related fields to calculate?) there is a restriction for one user, and that is limiting a view. I believe there is a field setting that is something like 'Use these permissions even if they are less restrictive'. Check to see if that option is available in the fields you are using in the calculation.

Also I would check to see if there are any filters on the report you are looking at.

There should be no delays. Others on this forum know a lot more, so maybe someone else has ideas!

------------------------------
Mike Tamoush
------------------------------
    Terms & ConditionsAccessibility statement