Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering when Runningsum function goes negative

Status
Not open for further replies.
cjfssc

cjfssc

Technical User
Joined
Jun 5, 2002
Messages
2
Location
US
I am using BO v5.1.2 and trying to do a simply Supply vs Demand time phased report. I have measures for Supply and Demand, then use the formula

Code: 
=RunningSum(<Supply>-<Demand>)

This gave me where my Supply exceeded or fell below my Demand.

I need to filter my report so it only shows items where the runningsum becomes negative.

The filter button is greyed on the runningsum and The runningsum is not available to filter through filter dialog box.

Any help would be greatly appreciated. Thanks
 
Status
Not open for further replies.

Similar threads

TracieN
  • Locked
  • Question Question
Previous Function in Webi
Replies
1
Views
1K
kray4660
kray4660
PWD
  • Locked
  • Question Question
Filtering BO Report &lt;= Date
Replies
3
Views
402
SkipVought
S
hmax
  • Locked
  • Question Question
Show Crosstab columns when no results
Replies
0
Views
193
hmax
hmax
sa0309
  • Locked
  • Question Question
Pass Query Filter values to a function
Replies
1
Views
295
hilfy
hilfy
LisaMarieC
  • Locked
  • Question Question
Java exception in Instance manager when attempting to see failed instances (unhandled exception)
Replies
1
Views
272
pelajhia
pelajhia

Part and Inventory Search

Sponsor

Back
Top