Displaying specific formula results in footer

[Seth21]

I have roughly 50 rows and each has a formula field called deviation.

I have assembled a process diagram in the footer and would like to have the some of the results from this formula in the footer.

Temp. Sensors Deviation
TE001 2
TE002 3
TE003 1.5
..all the way to 50


Anyway to do this?

 

[Seth21]

An example of something that would be nice if I could write a formula like below:

{@deviation} WHERE Temp. Sensors = TE003

 

[lbass]

What is the content of {@deviation}?

-LB

 

[Seth21]

IF {cr_trgraph1.Max_Spec}>={@Value} and {@Value}>={cr_trgraph1.Min_Spec} THEN 0

Else if {@Value}<{cr_trgraph1.Min_Spec} then {@Value}-{cr_trgraph1.Min_Spec}

else {@Value}-{cr_trgraph1.Max_Spec}



It is an if then statement seeing if {@value} is within spec, if it is not within spec then how much is it outside of spec.

 

[lbass]

When asked for formula contents, you should also show the content of any nested formulas, e.g., {@value}. The point is to see whether you are using any summaries or any comparisons that are sequential (cross records).

If {@value} just refers to items in the same row, you can just use formulas like this:

if {Temp. Sensors} = TE003 then
{@deviation}

Place this in the detail section and right click and insert a summary on it at the report level.

-LB