We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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.
