You’re offline. This is a read only version of the page.
Hello:
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 have 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.
The value that displays is correct, but it does not print a percentage symbol. The non-printing row (445) has this percentage symbol, already. So, why won't the If, Then statement use it? It prints the correct number for the percentage. But, again, no percent row displays.
What in the world?
John
*This post is locked for comments
I have the same question (0)
disregard....I will start a new thread.
Share
Report
All responses (
Answers (
