Getting value from previous column, from previous week

[#1]

Hello.

I've got something like this:

and I've got a question about this:

How could I make CurrentStock be equal to Bilans from previous week (Fabric_CW)?

I've tried a few solutions and none of them was able to get value from another week(for example, column() gets values only from the same week and isn't able to get values from another set of fields - here, from previous week)

[sunny_talwar]

May be this:

Before(YourExpression) //yourExpression needs to have a set analysis {<Fabric_CW = {'Bilans'}>}

[#3]

Hello,

Could you expand your answer?

Either it's not working or I don't understand it.

[sunny_talwar]

Can you share the expression you are using right now???

[#5]

It looks like this:

Bilans: Supply - DemandLeft (shortened version)

and expanded version (Bilans):

(SUM({<FACTORY_STOCK_ID>} S_FABRIC_SUPP_QTY_CON - S_FABRIC_SUPP_QTY_DEL)) - (IF(FACTORY_ID=FACTORY_STOCK_ID, SUM({<FABRIC_ID>}S_FABRIC_QTY), 0)) - (IF(FACTORY_ID = FACTORY_STOCK_ID, SUM({<S_FABRIC_CW>} S_FABRIC_NED), 0))

[sunny_talwar]

Would you be able to share a trimmed down version of your app or a sample to look at?

[#7]

I attached file with this table, Everything looks like this, but I'd like to have bilans from week 27 at week 28 (it can't be just calculated from the previous week, because I'll need it for much more weeks)

[sunny_talwar · Accepted solution]

Is this what you are intending to get?

If yes then please find attached

Best,

Sunny

[#9]

Yes, that's great.

I didn't know that it works like this, thank you very much!

[sunny_talwar]

No problem

I am glad I was able to help.

Best,

Sunny