Hello,
I am running a report that pulls pay changes, which it does just fine, until I add this Derived Field:
(("A"."COMPRATE" - "C"."COMPRATE")/"C"."COMPRATE") which I need to calculate Percent Change. No, I cannot use the percent change field, as it does not serve the entire purpose.
Second, even when the Percent Chg field is used, when a report variable is plugged in, so that the percentage must be equal to or higher than the given number, it seems to be completely ignored. This occurs whether the report variable is entered as a string or a number and with or without corresponding decimal places.
Any ideas are appreciated.
I am running a report that pulls pay changes, which it does just fine, until I add this Derived Field:
(("A"."COMPRATE" - "C"."COMPRATE")/"C"."COMPRATE") which I need to calculate Percent Change. No, I cannot use the percent change field, as it does not serve the entire purpose.
Second, even when the Percent Chg field is used, when a report variable is plugged in, so that the percentage must be equal to or higher than the given number, it seems to be completely ignored. This occurs whether the report variable is entered as a string or a number and with or without corresponding decimal places.
Any ideas are appreciated.