Which calculation is the problematic, can you give an example?
Not Certain I understand the calculation you are trying to do but see the attached
it will return this
the issues you have are 2 fold
first I converted "Product" to a dimension - I think that it is a product number used to categorize data
then I created 2 lod expressions
and then this which looks at the total montant ht in the current period / the count 2 periods back -
Not certain if you wanted sum() or Max() or something else
Window sum is going to give you a different result
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
278037back_v10.2.twbx 58.9 KB