Alteryx Designer Desktop Discussions

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

Calculating a difference on a diagonal

Hettie2102
6 - Meteoroid

I have a data set in the form of a triangle. Each column is a year, and each row is a month. The rows calculate the balance on a cumulative basis.  I need to be able to calculate the difference in the lead diagonal (therefore the balance on the diagonal, less the number on the row before it). Please see the document attached. . The orange 'number' needs to be subtracted from the red. But as the data set is on a diagonal I am unsure on how I can calculate this in alteryx. 

 

Any help would be greatly appreciated, thanks! Triangle representation for alteryx.png

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Hettie2102 

 

Interesting can you provide some sample data and excepted output

PhilipMannering
16 - Nebula
16 - Nebula

Interesting problem!

 

You could try something like this...

 

PhilipMannering_0-1605005796324.png

 

Hettie2102
6 - Meteoroid

Hi please see below:

 

Thanks 

PhilipMannering
16 - Nebula
16 - Nebula

Ah, think I misunderstood your question.

 

Try this,

 

PhilipMannering_0-1605006763937.png

 

Hettie2102
6 - Meteoroid

Thank you so much!

Labels