ColemenWilson, @GrantSmith. Any idea how to resolve this? any help will be highly appreciated! thanks in advance.

here's the thing see the YTD_22 column is '% of column total' see below Now I wish to see the difference just by SUM(YTD_22) - SUM(YTD_23) is not working because I'm using % of column total to get a share of market. In this case, this formula doesn't work, any other way around?

hi @MichelleH : thank you for your response, here is the challenge with my requirement. I cannot change any format at this time, I will have to simply read the files from my google drive that's it. But I was going through one of the connectors as 'Google Drive Service Connector' which is asking me permission as 'Connector…