+2
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?
Best answer by francois
View original
+13
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.
+2
Hi
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
+2
Hi
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 username or e-mail address. We'll send you an e-mail with instructions to reset your password.
