7 Replies Latest reply on Feb 21, 2016 5:36 PM by Shinichiro Murakami

    Adding Filtered Calculated Fields


      Hi all,


      Quick question regarding filtered fields.


      I'm trying to add two columns of data.

      Is it possible to filter one column and still be able to add the data together (only taking into account what is filtered.)


      For example.

      I am adding 100 from column X to column Y.


      I filter column X, and 50 is left on column X.


      My answer is still (100 + Y) but I want it to show (50 + Y)




      I do apologise if this is not very clear, I'm in a bit of a rush.