8 Replies Latest reply on Apr 5, 2018 1:55 PM by Deepak Rai

    Calculate Measure on Date Difference

    Hrishikesh Shanbhogue

      Hi,

       

      I have a data set where I need to calculate the net amount (difference between the "Original amount" of accounts opened - accounts closed) per each branch, I have "date opened" and "date closed" to indicate when the account got opened or closed .

       

      I have a bar graph with all the sum of opened account amounts for last 2 quarters per branch

       

      I have a bar graph with all the sum of Closed account amounts for last 2 quarters per branch

       

       

      I want to create a bar graph which shows the difference between the above two graphs (Net Income = Amounts Opened - Amounts Closed)