Syntax Calculation

[#1]

hi i have the following problem

using a dimension table pivot i am calculating stock level available.

i use the following Expression.

[Lagersaldo]

-

RangeSum(Above(sum(Order),0, rowno()))

+

RangeSum(Above(SUM(Purchased),0, rowno()))

however when i add another dimension to the table and expand the expression fails to act in the way intended.

any advice. please see attached document.

[Clever_Anjos · Accepted solution]

''Trick' way

Use WeekNo as an expression, not a dimension

[jonathandienst]

Hi

You may need to add total to the Above statements, eg

RangeSum(Above(TOTAL sum(Order),0, rowno()))

Jonathan