Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Calculation is not what I expected.


tomlepk

This topic is 8504 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a database with 'item', 'run name', 'tags run' and 'time'. I also have a calculation for tags per hour(tags run/time)unstored. I have 2 summary fields for total 'tags run SUM' and 'time SUM' these summary fields show the correct data. But if I create a field called 'labels per hour SUM' and make it a calculation of (tags run SUM / time SUM) the result is for the entire found set, what I want is for the individual items to have their own totals, what do I do? I have the database sorted by 'item', then 'run name' and I have the report parted out as header,sub sum item,sub sum run name,sub sum item,footer. The 'labels per hour SUM' is in the last sub sum item.

Every 'item' has anywhere from 1 to ... 'run names' i just want a run rate summary of those items not for the entire found set.

  • (I used underscores instead of spaces to simulate a fixed character width)

ITEM

___RUN NAME_________TAGS RUN____TIME________LABELS PER HOUR

FT1291C

___FT1291C730613_______49_______2.58_________18.992

___FT1291C730613-0_____41_______2.42_________16.942

___FT1291C730613-1_____16________.9__________17.778

SUMMARY OF FT1291C___106_______5.90_________22.776 (should be 17.966)

FX1001C

___FX1001C730608_______25_______1.14_________21.930

___FX1001C730608-0_____18________.59_________30.508

SUMMARY OF FX1001C____43_______1.73_________22.776 (should be 24.855)

Now that 22.776 is the calculation of entire found set, not from that individual line in my report how do I fix that.

Thanx in advance.

Thomas Lepkowski

Link to comment
Share on other sites

When performing calculation with values from Summary fields, you must use the Get Summary (field, break field) to extract the summary value you wish to use.

Your calculation should look like:

labels per hour SUM (calculation, number) =

Get Summary (tags run SUM, Item) / Get Summary (time SUM, Item)

If you want an overall average in a Trailing Grand Summary part, you should still use the Get Summary function any time you are performing a calculation on a summary field, but now is will look like:

Get Summary (tags run SUM, tags run SUM) / Get Summary (time SUM, time SUM)

Again the key is that you MUST use a Get Summary() function when creating a calculation using a summary field.

-bd

Link to comment
Share on other sites

This topic is 8504 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.