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!
Solved! Go to Solution.
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.
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
Please use Multirow Formula