1 of 1 people found this helpful
Here you go.
Create three additional calculated field for different format respectively.
USD, %age, and STD.
Put all three field onto "text" shelf.
Those never duplicate as long as you set formula correctly because it brig s null in "NOT" case.
Thank you Shin..
You are welcome.