Solved

Reallocation Logic

  • 22 June 2023
  • 2 replies
  • 40 views
Y
Rank
Userlevel 3
Badge +6
  • Yaejis Newly Minted Pigmenteer
  • Newly Minted Pigmenteer
  • 21 replies

Hi Pigment team! 

I am trying to setup a reallocation logic. Can you please help with creating the formula?

 

Right now, the total cost $1,517,587 is booked all in US (screenshot 1), but I want the cost to be re-allocated to international countries (screenshot 2). You will see the total still matches with screenshot 1. 

For my another metric for reallocation, what is best way to create a metric to show a table as screenshot 3? 

 

​​​​​​

 

Thanks in advance for reviewing!

icon

Best answer by abhilashsawla 22 June 2023, 07:22

View original

2 replies

abhilashsawla
Userlevel 4
Badge +6

Please Try below formula. 

if('Country Dimension'='Country Dimension'."US" , '[Final] Hosting Final Actual'[Exclude:'Country Dimension'."US"][Remove:'Country Dimension']*(-1), '[Final] Hosting Final Actual')

 

Y
Rank
Userlevel 3
Badge +6

It worked! Thank you!

Reply


Ask your question here!

Terms & ConditionsCookie settings