Skip to main content
Solved

Setting an object equal to 1000


Rocco
Budding Pigmenteer
Forum|alt.badge.img+2
  • Budding Pigmenteer
  • 6 replies

Can I set an object at aggregated level to be equal 1000 using a formula

 

example
‘Salary(euro)’ = 1000

Best answer by Nathan

Hi Rocco,

what do you mean by aggregated level ?

View original
Did this topic help you find an answer to your question?

8 replies

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • 207 replies
  • Answer
  • June 22, 2023

Hi Rocco,

what do you mean by aggregated level ?


Rocco
Budding Pigmenteer
Forum|alt.badge.img+2
  • Author
  • Budding Pigmenteer
  • 6 replies
  • June 22, 2023

@Nathan I would like to set an object with multiple dimensions (5 dimensions) to be equal to 1000 

Those 1000 should be spread down by the dimensions.
Is it possible with a formula?


Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • 207 replies
  • June 22, 2023

You can do like this (in concept):

 

1000[by split:dimension1,dimension2] 

that’s going to equally split the value over each items of the dimensions.

 

You can do more elaborate logic of course as needed


Rocco
Budding Pigmenteer
Forum|alt.badge.img+2
  • Author
  • Budding Pigmenteer
  • 6 replies
  • June 22, 2023

I would like all these cells to be equal to the number set, 

could you please help me make it work?

 


Rocco
Budding Pigmenteer
Forum|alt.badge.img+2
  • Author
  • Budding Pigmenteer
  • 6 replies
  • June 22, 2023
Rocco wrote:

I would like all these cells to be equal to the number set, 

could you please help me make it work?

 

@Nathan 


Franck C
Employee
Forum|alt.badge.img+4
  • Employee
  • 15 replies
  • June 22, 2023

If you want to see 1000 everywhere, just type 1000 in the formula.


abhilashsawla
Forum|alt.badge.img+7
  • Pigment Academic
  • 104 replies
  • June 22, 2023

Hi @Rocco 

Please follow below Steps:

  1. Create a metric (Data Type: Number, Dimensions: No Dimension) and provide input value 1000
  1. Create a metric (Data Type: Number, Dimensions: Country, Cost Center, Month,Account) and Write in Formula Bad 
    Amount[Add Split:Country,'Cost Center'][Add:Account,Month]

    Hope this will help you to achieve your requirement.


Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • 207 replies
  • June 22, 2023

@Rocco @abhilashsawla is right, ADD is the right keyword , not BY


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings