Can I set an object at aggregated level to be equal 1000 using a formula
example
‘Salary(euro)’ = 1000
Best answer by Nathan
View originalCan I set an object at aggregated level to be equal 1000 using a formula
example
‘Salary(euro)’ = 1000
Best answer by Nathan
View originalThose 1000 should be spread down by the dimensions.
Is it possible with a formula?
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
I would like all these cells to be equal to the number set,
could you please help me make it work?
I would like all these cells to be equal to the number set,
could you please help me make it work?
Hi
Please follow below Steps:
Amount[Add Split:Country,'Cost Center'][Add:Account,Month]
Hope this will help you to achieve your requirement.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.