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!
hey @Richie059
Can you attach your data for this please?
Its possible by transforming the data first - happy to show you 🙂
Cheers,
TheOC
@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.