Dear community,
May i know how to write the formula in order to derive the result below to replicate the data? The objective is to check the column A if contain the "period", if yes, get the column B as Month Ouput. If no, then continue to use the previous data that contain "period".
Many thanks for the help.
Solved! Go to Solution.
Hey @SH_94, for this request we can use the Multi-Row Formula with the following expression:
if [Decription] = 'Period' then [Detial] else [Row-1:Month] endif
Hi @SH_94 ,
I believe this is what you're looking for :D!
Let me know if this is working for you.
Greetings,
Seb