Preforming calculations on multiple columns (Current Ratio)

[Richie059]

Hey guys, I hope everyone is doing well. I need to preform calculations on this data by the year. For example, I need to be able to calculate the "current ratio" which is a company's current assists / current liabilities.  In this care would be ((Cash & Equivalents + Receivables) / (Accounts Payable + Income Tax Expense) I've tried everything I can think of to no avail, I'd be very grateful for your help. Thank you so much!

[TheOC]

hey @Richie059 

Can you attach your data for this please?
Its possible by transforming the data first - happy to show you 🙂

Cheers,
TheOC

[Qiu]

@Richie059 
Yes, the data, rather than picture is always better.
I use OCR to somehow get your data and we should use Transpose and Cross Tab tools in this case.