Multi-row and run total calculation

Hi! I am looking for some help. I am trying to configure the multi-row formula and run total to copy the calculation form excel, but with no luck. Basically I am trying to calculate when Im going to run out of some items, depending on the demands and qty on in each group. So if column A becomes negative, then i am taking the items from B, if B becomes negative, then I go to D. Hope it makes sense. I would appreciate any help. help alteryx.png

forum help.xlsx

Accepted answers

brendafos

The Multi-Row formula only looks up or down a single field/column.

But you can use the Multi-Row on each column and create a flag for each column (has negative count = T), then use a Multi-Field tool to build a formula that looks at the three columns.

I am assuming you will have multiple categories to group on - which both the Multi-Row and Multi-Field tools will do for you.

RobertOdera

Hi, @munchkin100

Please mark as an acceptable solution if this works for you.

Source File set up

Solution Result

Workflow Canvas

Multi-row Formula Tool configurations

For_munchkin100.yxmd

All comments

brendafos

The Multi-Row formula only looks up or down a single field/column.

But you can use the Multi-Row on each column and create a flag for each column (has negative count = T), then use a Multi-Field tool to build a formula that looks at the three columns.

I am assuming you will have multiple categories to group on - which both the Multi-Row and Multi-Field tools will do for you.

RobertOdera

Hi, @munchkin100

Please mark as an acceptable solution if this works for you.

Source File set up

Solution Result

Workflow Canvas

Multi-row Formula Tool configurations

For_munchkin100.yxmd

jarrod

Hi @munchkin100 ,

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

Thank you!

munchkin100

@RNO Thank you very much!!!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280