I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot.
Since the module is set at quarter, you can use the PREVIOUS function.
If C<>0 then C else PREVIOUS(C)
Make sure you set the first condition as the most likely. If C is most likely not zero then that should be first like the above example.
Aha! a year to year approach. Love it.
In that case use OFFSET. Go back 4 periods.