Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Preforming calculations on multiple columns (Current Ratio)

Richie059
7 - Meteor

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!

 

 

Richie059_1-1640038388646.png

 

2 REPLIES 2
TheOC
15 - Aurora
15 - Aurora

hey @Richie059 

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

Cheers,
TheOC


Bulien
Qiu
20 - Arcturus
20 - Arcturus

@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.

1221-Richie059.PNG

Labels