Forum Discussion

sokatenaj's avatar
sokatenaj
Advocate II
8 years ago

Sum issue

Hi Folks,   Trying to do something with 6 stock periods, though the table below only shows 3. I have employees that have 6 columns of shares with different vest dates. What I want to do is Sum acro...
Need Help
parry2k's avatar
parry2k
Super User
8 years ago

What expected output you are trying to achieve?

  • sokatenaj's avatar
    sokatenaj
    Advocate II
    8 years ago

    parry2k The total # of shares of each employee based on the date range. 

     

    Basically, all I want to see the total shares each individual has on a date range of Nov 1 2017 up to December 31, 2022. Problem is that they get a batch of shares at each vest date. Plus some of the data has shares already vested which I don't want which is why I need the date range. 

     

    Many thanks!!!!!!

      • sokatenaj's avatar
        sokatenaj
        Advocate II
        8 years ago

        Thanks parry2k, but I can't undo the data like that because the sum of shares for each employee needs to be rolled into a table visual with other employee data. There are thousands of rows and I get new feeds daily so need to automate it better some how. 

         

        There must be a different way to create it as a measure so that I can plop it in a table visual...