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!

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

How to understand this formula?

Status
Not open for further replies.

wanzek1

Technical User
Jun 13, 2012
79
US
I am editing someone else's report and I need some help with a formula. Can someone help me understand this type of formula?

WhilePrintingRecords;
Numbervar JobEndSubPhase;
JobEndSubPhase := JobEndSubPhase + {@JobEnd+-}

I understand most of it the part I don't get is this part:
JobEndSubPhase := JobEndSubPhase + {@JobEnd+-}

This field is a formula: {@JobEnd+-}

But where does this come from: JobEndSubPhase

I can't find it in another formula.

Thanks!
 
It's a variable that is defined within the formula.
It may also be defined in another initialization formula, typically placed in the Report Header.
 
What I don't understand is that it appears they are adding something to a field:

JobEndSubPhase + {@JobEnd+-}

Say {@JobEnd+-} = 200

JobEndSubPhase + 200

Is the answer 200?
 
Wanzek1,

This is a Running Total, where each time the formula "triggers" the value of the variable "JobEndSubPhase" is incremented by the value of the formula field {@JobEnd+-} in the same instance.

Example:
[tt]{@Formula in Question} ... {@JobEnd+-}
...... 200 ................... 200
...... 350 ................... 150
...... 450 ................... 100
...... 600 ................... 150[/tt]

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."
 
This helped and I was able to create another one and get it working.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top