6 Replies Latest reply on Feb 24, 2016 12:15 AM by carlos.sanzporro.0

# create a repeat value - variable

• ###### 1. Re: create a repeat value - variable

Carlos!

Change the formula for your variable week number to this:

{max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END)} 1 of 1 people found this helpful
• ###### 2. Re: create a repeat value - variable

Here you go.

Shin

[Does this work]

{fixed:min([Variable Week Number])} Thanks,

Shin

9.2 attached.

• ###### 3. Re: create a repeat value - variable

one minute again....

• ###### 4. Re: create a repeat value - variable

Perfect, but... what is the difference between {max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END)} and max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END)? Have you any links/documentation about use "{}"? thanks

• ###### 5. Re: create a repeat value - variable

LOD

Overview: Level of Detail Expressions

{max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END)}

= {fixed :max(max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END)}

max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END) is only effective to specific dimension,

but LOD is effective for all nevertheless of dimension.

Thanks,

Shin

• ###### 6. Re: create a repeat value - variable

Thanks for the clarification. {fixed :max(IF([Year] = [Today Year] AND [Week] = [Today Week]) THEN [Week Number] END)} perfect!