Set analysis expression

[Anonymous]

Hi  All

I have a cyclic dimenssion (year ,month, Quater )  and i had return the  expression as  follows

=sum({<Test4-={0}>}Test4)+1 .By this i am getting the output as expected .

But the problem is  for month and year we have  dates up to  2020.  and Test4 data is up to current month  .

By adding +1 in the expression  my chart shows value 1 in the chart  from 2017 Feb to end of 2020.

I want restrict that and i want to show it  beyond current month i.e FEB 2017 that +1 values

(Note: I want to do in the expression   )

Can please advice me .

[sushil353]

Hi,

I think you are checking null/zero values in Test4, so for in case of cyclic dimension try to use if condition

if( isnull(Test4),sum(Test4),sum(Test4)+1)

HTH

Sushil

[varshavig12]

Try this:

=sum({<Test4-={0,''}>}Test4)+1