A question on function "then"

[Pei Hsuan Shen 2]

I am reading the document onhttps://docs.tibco.com/pub/spotfire/7.0.0/doc/html/ncfe/ncfe_using_expressions_on_aggregated_data_the_then_keyword.htm.

The example shows that

"Examples:

Instead of: Sum([sales]) OVER (AllPrevious([Axis.X]))

Use: Sum([sales]) THEN Sum([Value]) OVER (AllPrevious([Axis.X]))".

 

But as far as I know, Value is equal to Sum([sales]). So, the use becomes that

"Use: Sum([sum([sales])]) OVER (AllPrevious([Axis.X]))".

I am confused. Can someone tell me what wrong is

[Khushboo Rabadia]

That example is very simple example so

Sum([sales]) OVER (AllPrevious([Axis.X])) =Sum([sales]) THEN Sum([Value]) OVER (AllPrevious([Axis.X]))

If there is a usecase to sum up avg values ofall previous X-Axis then it can be easily done with "THEN" like

Avg([sales]) then Sum([sales]) OVER (AllPrevious([Axis.X]))