G
Guest
I have a report that allocates a cumulative
liability/asset based on the cumulative components of the
liability. The problem is that when the liability becomes
an asset (or goes to 0) our partner wants the cumulative
components to be reset so that the liability/asset
reported between us is more responsive to changes in the
components. If I could group on a calculated control in
the report that indicates when the cumulative liability
asset is positive or negative this would be fairly simple
but I can when I enter the control name as a grouping
level the report does not recognize this as a field. I
have tried using a expression that is based on the same
formula as the indicator control but the when the report
runs I get a "comma" error and the report runs ignoring
the grouping for this level. Any suggestions on how to
use expressions in grouping are welcomed.
liability/asset based on the cumulative components of the
liability. The problem is that when the liability becomes
an asset (or goes to 0) our partner wants the cumulative
components to be reset so that the liability/asset
reported between us is more responsive to changes in the
components. If I could group on a calculated control in
the report that indicates when the cumulative liability
asset is positive or negative this would be fairly simple
but I can when I enter the control name as a grouping
level the report does not recognize this as a field. I
have tried using a expression that is based on the same
formula as the indicator control but the when the report
runs I get a "comma" error and the report runs ignoring
the grouping for this level. Any suggestions on how to
use expressions in grouping are welcomed.