Skip to main content
Solved

Hard Selection on the target metric

  • 19 July 2023
  • 3 replies
  • 323 views

Hello Everyone,

I have in the following 2 dimension: Year & “Year1”

from the FTI formula I hard selected the 200 from the Year.”FY 23”. Year is the only dimension

How do I hard select on the target metric just one random cell, like the one highlighted below?
 

 

Hi Rocco,

You could create an access rights metric in the security folder with the same dimensions as this metric, and either manually change the values or type something like IF(Year = Year."FY 26" AND Year1 = Year1."10", ACCESSRIGHTS(TRUE, TRUE), ACCESSRIGHTS(TRUE, FALSE)). You can activate that AR rule in the security settings.

This will enable write access on that cell and forbid anyone to type things on other cells.

Hi @francois,
What you are saying is more than correct,
however what I am trying to build is more than what I am showing, hence I am still looking forward a formula.
My goal is to improv on Pigment Formulas & modeling.

 

However, I really do appreciate your response so far,
Merci Beaucoup 

Hi @Rocco!

 

I hope you’re doing well! I have a few questions for you so that I can help better:

  • Can you please clarify what you mean by “Hard Select”?
  • Are you wanting to choose a specific value for use in a formula for another metric?
  • Do you need to retain the dimensions after the “Hard Select”?

Any context you can provide will help greatly :)

Reply


Ask your question here!

Terms & ConditionsCookie settings