Statistical Indicator characteristic in FMRP_RW_BUDCON
We would like to select only real postings in the actual column of FMRP_RW_BUDCON. We have copied this report as a new custom report to make adjustments. When you select the statistical indicator characteristic, and try to choose blank as the value (because blank is the correct value for real postings), it will not accept blank as a valid value.
So the only option I've been able to come up with is to create additional columns as follows:
Column 1: Actuals regardless of rstats value. This column will be hidden
Column 2: Actuals with rstats = y or x. This column will be hidden
Column 3: Calculated column = column 1 -2. Column 3 will be labeled actuals
Does anyone have a suggestion that doesn't include creating all of these columns?
Thank you in advance for your help!