Forum Discussion

Rdarshana's avatar
Rdarshana
Helper II
2 years ago
Solved

How to display Inverse Percentage for a Field?

Hi, I have a field that displays the value as 0.73, 0.82, 0.91, etc,. The need is to display these values as Percentage.  But, this needs to be inverse percentage - that is: 1-0.73 = 0.27 ~ 27%....
Need Help
Tips and Tricks
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Rdarshana 

    you can try to create a new column

    Column = 1-'Table'[Column1]
    and set the data type to percentage
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    pls try this

    measure = 1- max(Original Col)

ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

pls try this

measure = 1- max(Original Col)

Rdarshana's avatar
Rdarshana
Helper II
2 years ago

So, I tried this - 

New Measure = 1-MAX(table name [ columne name]), and it still displays 1.00.

Thus, for now, I shall retain this as a new column in the current table, since that is working.