Hi I have a question on a calculation:
I have a column with percentage values
Column A:
100%
116%
50%
80%
102%
I need a calculated field that can give me values to 8%.
ie; If Column A = 100% then 8%
If Column A = 50% then 4%
and if more than 100% then keep it to 8%.
Can we do this?
Multiply your Column A values with 8 and Divide by 100, and see if it gives you the desired results.