Alteryx Designer Desktop Discussions

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

Add month over month values using growth rates (example 10%)

saurav_palekar
7 - Meteor

Hi everyone, I'm new to the Alteryx community!

 

I would like to add values in a column based on previous value. The next value in the column should be based on the previous value and so on.

I have dates, segment 1, segment 2, and Values as columns.

Some cells in values columns are blank and needs to be filled based on previous date's values by adding 10% growth rate.

Example 

Please find the excel file for reference!

 

Thank you so much!

 

 

12 REPLIES 12
saurav_palekar
7 - Meteor
 

Hi Kamal! Sorry, I didn't asked the question correctly, please find the attached data file.

In case of 2 different growth rates - how can I fill the remaining values.

For 'Segment 1 = XYZ and Segment 2 = ABC', the growth rate is '10%'

BUT

For Segment 1 = XYZ and Segment 2 = DDD, the growth rate is '15%'

 

Basically 2 different growth rates for 2 different combinations.

 

I have attached the updated file for your reference.

 

Please let me know if you have any questions regarding this. 

image.png

kamal03
9 - Comet

Cool, Here is the updated workflow, please let me know if it works or not.

 

Here is the formula which you need to write in multirow formula : -

 

if [Segment 1] ='XYZ' and [Segment 2]='ABC'
then
(if isnull([Values]) then (0.10*[Row-1:Values])+[Row-1:Values]
else
[Values] endif
)
elseif [Segment 1] ='XYZ' and [Segment 2]='DDD'
then
(if isnull([Values]) then (0.15*[Row-1:Values])+[Row-1:Values]
else
[Values] endif
)

else [Values]
endif

 

 

 

 

Thanks

malteryx1
6 - Meteoroid

Please use Multirow FormulaScreenshot (7).png

 

Labels