Forum Discussion
Populating last months data for items with missing value
Hello, Can someone assist me. I attached a file of data below. Ultimately I am looking for the EOM balance for certain items where I can then break down the data by month afterwards. I have ma...
Hi Anonymous
Thanks for reaching out to us.
One idea, in this case, you have to create a secondary table containing all the months, and then calculate the February value in the auxiliary table. When calculating the value of February, you need to use the if() function to determine it, and if it is blank, get the value of January and assign the value to February.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.