Hard Selection on the target metric

  • 19 July 2023
  • 3 replies

Userlevel 2
Badge +2
  • Budding Pigmenteer
  • 6 replies

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 19 July 2023, 16:58

View original

3 replies

Userlevel 6
Badge +14

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.

Userlevel 2
Badge +2

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 

Userlevel 3
Badge +4

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 :)