Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.
