# Calculating inside dynarange does not work correctly...

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

• # Calculating inside dynarange does not work correctly...

Hello,

I have a cube that lists aids. each has a beginning date (as a dimension) and a ending date (as a dimension).
I want to calculate the difference: beginning - ending aids.

So I put three dynaranges amoung each other
y-axis is always the category of the aid.
x-axis is
- for the first one beginning date
- for the second one ending date
- for the third one beginning date (beginning and ending date dimensions have the same range)

I now want to calculate for every cell the cell in the first minus the cell in the second table.

So I put =E9-E14 into the third dynarange. E9 = palo data function for first table, E14 for the second.

It seems that each result in the third table always refers to always to E9-E14 and not D9-D15, D10-D16 and so on.

I thinks I've done something wrong.. How can I make jedox to calculate with the correct cells?