ContributionsMost RecentMost LikesSolutionsRe: Capped Commission Calculation You might already have an answer, but I think you want to use MIN not Max. Re: Data refreshMark and you were correct - permission issue! Thank you! ------------------------------ Karen Smith ------------------------------ Data refreshI 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 ------------------------------Not Saving AutomationsI am working on some automations and I have a problem that the automation is not saving. The trigger is saving and the list of actions is saving. The filter for each step is saving. But if the action is "copy records" or "modify records" it looks like everything saves, but when I go back the list of fields that I selected to change is no longer correct - different fields are listed and there is no change listed. Has anyone experienced this before? Suggestions? ------------------------------ Karen Smith ------------------------------