If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Stand Alone Calculation

Started by jv_oz, 03 Oct 2017 11:28:09 PM

Previous topic - Next topic

jv_oz

Hi everyone,

I have an odd one. I have a series of query subjects that build to provide a summary output of the sum of the time for production tasks to be completed vs the time available until production line needs to advance for each workstation on a production line. I have calculated the difference as C = B - A, where B is the number of minutes until the line advances (expressed as a decimal, so 73.5 represents 73 minutes and 30 seconds) and A is the sum of all the time required to complete all tasks at a workstation (also decimal). C then represents the difference to tell us if we need to throw more resource at a workstation to complete on time or not. All calculations need to be completed in FM because we are using CA 11 Dashboards, where you can't do calculation in the dashboard.

I have A and B calculating correctly in FM and have set C as Stand Alone Calculation and have then added C back into the query subject. I have 578 mins as A and 617 minutes against B. C should therefore calculate out to be 617-578=39 minutes, however C is calculating using the value in column A for the first record (2.5 minutes), rather than the sum of A.

For your info, the source is Oracle, I have defined the query subject as a "Summary Query", the Regular Aggregate for columns for A is set to "Sum" and B is set to "Average" (because the time until the line advances is  the same for all tasks and to add it up would be incorrect). The calculation C references these two columns.

Also it is interesting that if I place all columns from the query subject into a report and do the calculation of C = B - A there, it works perfectly.

Any advice you could give would be most appreciated!

Thanks

John