Share
ReportHello:
I had to start a new thread from a previous one, because I need to explain more full what the issue is.
I have a row that correctly calculates the Gross Margin (GM). I, also, have a row that calculates a Gross Margin Percentage (GMP).
Now, I'm trying to get a row after the GMP that is an if, then statement that says "If the GM is >0, then print the GMP, otherwise don't print it." (I'm trying to not print negative percentages.)
Anyway, here is my if, then formula: IF @430>0 THEN @445
Row 430 = GM and 445 = GMP. 445 is, actually, a non-printing row of the following formula: @430/@310; "0.00%;(0.00%)"
Row 310= Net Sales, of course.
There are two problems. First, the GMP is printing without a percentage symbol. Second, and even worse, whether the GM is negative or not, the GMP is printing. That goes against what the If, Then statement should be doing.
I have reviewed FRx's help on this. No luck.
What in the world? Is this simply not possible in FRx? What about Management Reporter?
John
*This post is locked for comments
All responses (
Answers (
291,269
