Julius Benn Sabeniano Posted June 27, 2020 Share Posted June 27, 2020 Hi, I understand that we can use over and interset functions whenever we need to sum or count values in a specific group. But, what if I would like to get the sum of the values in a Y-axis not adding up the same values or duplicate values. (sum of distinct values) I would like to get the sum of the slider count by Date not adding up the duplicate values from the column value. Link to comment Share on other sites More sharing options...
Julius Benn Sabeniano Posted July 2, 2020 Author Share Posted July 2, 2020 I used this functions to rank the duplications to my data and if statement to null the duplicate values.Sum(If(rank(baserowid(),"asc",[unique column])=1,[values],null)) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now