Can someone tell me how to format text in a column calculation?
For instance the NM is the text. I tried both the " and ' but they gave me an invalid character error. Is there a way to do this?
IF (B/C)>1 THEN "NM"
Thank you,
Angie
*This post is locked for comments
Angie,
In FRx, this used to work. The way it was executed involved creating a row with the text you wanted to display and referencing the row with the text in the column calculation.
If B/C > 1 THEN B.101 (row 101 was where our description text was located)
I tried this, this morning with B.101 and B.@101, and a number of other variations, with no luck. Perhaps this is a feature that didn't make it into Management Reporter, or is executed in some other fashion.
I referred to the manual, and poked around the Internet. The closest I came to answer was a March 2009 post on the FRx implementation of this feature.
www.frxbuzz.com/using-if-then-calculations-in-frx
This may not be possible.
Hi,
Have you tried XCR code on the column in MR.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,309
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
