Need help to change the values in a matrix

Hi, I have a matrix similar to the table posted below. The first column are my origin stations and the first row is my destination stations. So while going from station A to B - there were 90 people. When I travel from station A to A, from B to B - it should be 0 and I was able to specify that. There is a 0 diagonal. Due to a requirement, all the numbers below the diagonal need to be zero too. So from station B to A, instead of 38 it should be 0 and likewise for all the cells below the diagonal. How can I do that?

	A	B	C	D	E
A	0	90	30	17	55
B	38	0	98	15	53
C	52	74	0	17	13
D	100	58	29	0	78
E	78	84	69	28	0

Output

Preparation

Accepted answers

DavidP

Hi @Suvasini

Let me know if this works for you and I can explain a little more of my methodology.

Matrix.yxmd

All comments

DavidP

Hi @Suvasini

Would something like this work?

update matrix values below diagonal.yxmd

Suvasini

DavidP (16 - Nebula)

Thank you for the quick response. Appreciate it, I tried the solution you sent, but the stations are headers itself so there is no F1,F2,F3 etc in my workflow. Also when there is a 0 value above the diagonal it doesn't seem to work as it makes all values below it zero. Would request your help again. I have attached a workflow with the data set close to what I'm working with. The idea remains the same that below the A-A, B-B diagonal (which is already 0), cells below it have to be zero too.

Matrix.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703