calculation field recalculation

[independentCreations]

i have a complex set of calculations and relationships to allow me to have a list view of one table with an expanded view of any given record in that table below it on the same layout.

It is for timesheets i have tables:

X(weekly timesheet)

Y1(daily timesheet linked only via id code)

Y2(daily timesheet linked via id code & filter for the day. monday, tuesday...etc)

X(project/task logs for that given day)

this is all working the problem arises when i am falling back through the hierachies and calculations are depending on calculations.

1 flows perfectly to 2 (a sum of all 1's). it also flows perfectly to 3 (same as two but different table instance). it won't always flow into 4 though. (the whole bottom row is the same problem). if i refresh the screen it will recalculate and be correct. Is there a way to force this or even better ensure that it works as excpected.

Below is the image. with things marked etc.

any input is great. thanks in advance.

Brendan

Edited August 30, 2007 by Guest

[David Jondreau]

I've seen calcs that rely on related tables not refresh without taking some other action. A button labeled "Recalculate" that runs a script that contains the steps Commit Record and Refresh Window [Flush...] will probably be your best bet.

[Søren Dyhr]

Ditch the urge to make a listview, and use relations for the stuff instead, the aggregate functions freshen much better than shown summary fields....

--sd

test.zip

[independentCreations]

i went the refresh button way, it works now but i guess it's not ideal. the example u sent me i have working within mine, it was the next tier down that wasn't flowing.

i am using relationships to get what i want. below is my schema

maybe this will be more helpful?

if not thanks for your help again

Brendan

Edited August 30, 2007 by Guest

[Søren Dyhr]

maybe this will be more helpful?

No not really, I'm really wondering why do you have both weekly and daily timesheets when the later is a subset of the first, when things not are freshing in an appropriate manner is it usually a matter of relocating the field that forces the evaluation of the equations.

In your case is it aggregate functions which are my first candidates to pull it off in the green TO of yours, you can't expect anything happen in summary, GetSummary or Summary fields a relational step away.

Couldn't I get a look ar you calculations that hang?

--sd

[independentCreations]

Timesheet Project Entry::Normal Hours

Unsorted, =If (Type = "Nomral"; Logged; 0 )

Timesheet Daily::Total Normal.Daily

Unstored, from Timesheet Daily.Filtered Sum(Timesheet Project Entry::Normal Hours)

Timesheet Weekly::Normal Hours

Unsorted, Sum(Timesheet Daily All:: Total Normal Daily)

This passes the normal hours up the hierachy to the weekly total normal hours. Thats my calculations. Simple.