2 Replies Latest reply on May 30, 2016 6:04 AM by Nellie Rajarova

    Subtract using a subcategory (creating calculated field using subcategory)

    Nellie Rajarova

      In my excel sheet I have a column called category and I need to create a calculated field that would give me A+B-C.  I can do it easily when I have the file in the format with three columns A, B, C instead of category, but the format of my file is like the one below. Please let me know if we can do calculated fields using the subcategories (that is values in the column category)