Solved

# Setting an object equal to 1000

• 8 replies
• 139 views

Userlevel 2
+2
• 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

### 8 replies

Userlevel 6
+11

Hi Rocco,

what do you mean by aggregated level ?

Userlevel 2
+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?

Userlevel 6
+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

Userlevel 2
+2

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

Userlevel 2
+2

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

@Nathan

Userlevel 4
+4

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

Userlevel 4
+6

Hi @Rocco

``Amount[Add Split:Country,'Cost Center'][Add:Account,Month]``