+2Hello 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?
Best answer by francois
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.
+13Hi 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.
+2Hi
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
+6Hi
I hope you’re doing well! I have a few questions for you so that I can help better:
Any context you can provide will help greatly :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
