Solved

Setting an object equal to 1000

  • 22 June 2023
  • 8 replies
  • 138 views
Rocco
Rank
Userlevel 2
Badge +2
  • Rocco Budding Pigmenteer
  • Budding Pigmenteer
  • 6 replies

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

 

example
‘Salary(euro)’ = 1000

icon

Best answer by Nathan 22 June 2023, 13:38

View original
Rocco

8 replies

Nathan
Rank
Userlevel 6
Badge +11

Hi Rocco,

what do you mean by aggregated level ?

Rocco
Rank
Userlevel 2
Badge +2

@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?

Rocco
Nathan
Rank
Userlevel 6
Badge +11

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
Rank
Userlevel 2
Badge +2

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

could you please help me make it work?

 

Rocco
Rocco
Rank
Userlevel 2
Badge +2

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

could you please help me make it work?

 

@Nathan 

Rocco
Franck C
Rank
Userlevel 4
Badge +4

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

abhilashsawla
Userlevel 4
Badge +6

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
Rank
Userlevel 6
Badge +11

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

Reply


Ask your question here!

Terms & ConditionsCookie settings