Set a cell to specific value

• 

  Ole Dyring

  October 07, 2022 08:47

  Hi Joel,

  You can create a conditional calculation where a specific row, a specific dimension value, should be treated differently than the other rows.

  Example 1. I want France to have a specific value of 1,000,000. The other countries should just keep their measure value.

  

  This can be done as:

  if allcount(d1, d1:0, m1) = 3, m1) then 1000000 else sum(d1, 0, m1)

  Or as:

  if allcount(d1, d1:0, m1) = allcount(d1, d1:@"[France]", m1) then 1000000 else sum(d1, 0, m1)

   

  Example 2. If France is member of a real hierarchy:

  

  if allcount(d1, d1:0, m1) = allcount(d1, d1:@"[Europe].[France]", m1) then 1000000 else sum(d1, 0, m1)

   

  Example 3. If France is member of a custom hierarchy (two or more different dimensions on same axis):

  

  if allcount(d1, d1:0, m1) = allcount(d1, d1:@"[2021]";"[France]", m1) then 1000000 else sum(d1, 0, m1)

  I hope this makes sense.

  BR / Ole

  0
• 

  Joel Guttman

  October 07, 2022 10:43

  Exactly what I needed!

  Thanks a lot!

  BR/Joel

   

  0

Please sign in to leave a comment.