Cumulative total - Multi Row Formula (Including current row dynamic result)

minvestis

Hi,

Can anyone help to achieve following result in Alteryx?

I attached same data file to make test on it.

Thanks

Mayank

Sample Data- Alteryx.xlsx

Tips and Tricks

Transformation

Dynamic Processing

Accepted answers

geraldo

@minvestis

Substitute the formula from the mult row formula for this one:

if [Month] <= [MonthEnd] and ( IsEmpty([Row-1:ProjectID]) or IsNull([Row-1:ProjectID]) or [ProjectID] != [Row-1:ProjectID]) then ([Total PC%] * [Budget]) - [Running Total]
else ([Total PC%End] * [BudgetEnd]) - [Running Total End]
endif

minvestis

Hi @geraldo,

Thanks for sharing new formula. It worked as expected.

Appreciate your help and support.

Thanks

All comments

minvestis

Attached file contain excel formula for Expected Output and I want to achieve same in Alteryx.

Appreciate help in advance.

Thanks

Mayank

ShankerV

Hi @minvestis

One way of doing this.

However I see a small difference from your output shared.

Many thanks

Shanker V

Qiu

@minvestis
We can also try with an interative macro as below.

0518-minvestis.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703