Hello everyone,
I would like to know if you can help me with my formula... Let me explain: I have a personalized online table according to what the client requested. For each Item I have an associated formula. What I want to achieve is to add the result of the previous period to the following month and so on.... As I show in the attached file. PS: The values do not come from the Inline table, but from other tables. .Thank you !!!!
My Formula:
Script:
Bases_TP:
Load * Inline [
Bases_TP,
Ask,
Pron,
Evolution];
Measure:
If(Bases_TP = 'Ask',Sum(QTY),
If(Bases_TP='Pron',Sum(UNITS),
If(Bases_TP = 'Evolution', Sum(QTY) - Sum(UNITS),0)))
