5 Replies Latest reply on Feb 17, 2016 8:37 AM by Yuriy Fal

    taking difference of two columns that are the % of total

    youngji seo

      Hi, Sorry I wasn't able to find a solution in previous discussions though Im sure this has been asked before and shouldnt be that difficult. So below I have A and M from the MGRRESPCD field filtered for 2015 and set it to be % of total down. Now all I want to do is add one more column that will give me the difference ( A-M) so for australia 2.23%-1.2% which is so easy to do in excel but I can't figure it out here. I think Im running into trouble because the % is already a calculated field? But not letting me take the  difference of the % of the total. Can anyone help? thank you!!