I'm trying to create something like a "MRP" table. The picture below shows (sort of) what I want to obtain.
My question is, how could I perform a calculation on which, the first result uses a "fixed value" from a datasource, and the rest of results use the "last result calculated"?
Result_1 = Fixed_Value - m_1
Result_2 = Result_1 - m_2
Result_3 = Result_2 - m_3
m's also come form the datasource and are date-dependent.
Any help please?
I don't know how your data is structured but have you considered using PREVIOUS_VALUE()?