Problem with THEN

[Estefano Cayo Guzman]

Greetings Spotfire Community :

Excuse me for my poor english.

I have a problem with this expression :

 

ERROR :OVER expressions can only reference columns in the main data table

With this expression, i try to divide the cumulative sum of [Chrono].[NbDays_SPRG] by the cumulative sum of [GPS].

When the two cumulative sums are separated, it works so i think the problem is THEN.

 

If you have a solution to divide these cumulative sum, please tell me.

[Richard Pobi]

You need to create a calculated column first and add it to your cross table cell values. Try the below expression,

Sum[GPS] over (intersect [Year],allprevious[Month])/

Sum[Chrono],[NbDays_SPRG] over (intersect [Year],allprevious[Month])