Hi
Please help me in replicating PRODUCT excel formula. Req1 column is Cumulative for each attribute, Req2 is Cumulative of 3 months, Req 3 is YTD Cumulative. Also attaching the excel.
Thanks in Advance.
Hi @Mysa,
Please see the attached workflow. I'm fairly certain that the output columns match your expectations now (i.e. I've managed to wrap my head around what you were using the PRODUCT function for in Excel).
There are now three additional columns added called Req1 (B), Req2 (B) and Req3 (B) that match the corresponding Req columns from your sample file.
There's no denying I've made a meal of it but I think (I hope) I got there in the end. 🤣
Shifty
@Mysa
This is now doubt a fiddly one (for me at least but I'm no expert!). It's pretty much achievable with the Multi-Row Formula. I've attached a workflow that addresses Req1 and Req3. I'm still working on Req2 for you!
Take a look and let me know if that does tick off Req 1 and 3 for you.
Hey @Mysa,
I've updated the workflow to include all three Reqs. Let me know what you think!
Cheers,
Great solution @Shifty !
