If Condition

[#1]

Hi,

I need to show 'month' values based on 'Mob' values as shown below (assume current month as 201005):

If Mob=3 then month=201002(i.e. Current month-3) or 200902 (i.e. Current month-3-12),

similarily if Mob=4 then month=201001 or 200901.

Is there a way to do so using 'If' condition?

Kindly help ASAP.

[#2]

Please reply anybody.

[brenner_martina]

Hi,

is your filed month a datefaield? You have lots of datefunctions, look at the helpfile. also set analysis will help.

Or you can use the function Left(month,4) in dimensions and/or expressions.