i have defined in report layout as
e.g.

i want to track booked hours and budget houtrs

defining as print expression = booked hours
and in conditions(aggregate function) = total

i am getting total booked hours against employee correctly. no problem

when i want to compare with employee budget hours against week

e.g. 1 week 60 hours

how to compare between booked hours and budget hours difference want to print only (balance to book hours)

how to define in the balance to book hours report layout.

please suggest

Hi,

the aggregate functions in baan reports are very limited and cannot be used for further calculations (okay, there are workarounds, but I would not suggest them).

Instead: calculate the sum on your own.

To do this: (create a report script); add a local variable to it; whenever you print it, add the printed value to your sum; after you are finished with the group, don't forget to reset your sum to 0.

Günther

how to compare between booked hours and budget hours difference want to print only (balance to book hours)

how to define in the balance to book hours report layout.

please suggest

In expression write booked_hours - budget_hours and aggregate expression write total . That should yield difference .

But mind well same will not go ahead with division/multiplication / percentages as gunther has already pointed out.

While there is definite method to manipulation with aggregate quantities in the report script , there is still better way which can give the summaries fastest way and that too without affecting reports in upgrades / change of functionality in report.

This way is very useful when users need 5-10 page summary without 1000s of page detail lines . Have a look at speed data tranformation though performance dll (http://www.baanboard.com/baanboard/showthread.php?t=28569) .

With use of this dll the reports come at lightning speed and users really use the reports which come out of millions of detail lines.

In this case you hv to use the report script.

Define a field bal hrs. and total booked hours
Insert a detail line, do not show and field on this layout
In before.layout of this add booked hours and budget hours
put lattr.print = false so detail line line will not be printed

Then on before.layout of after.field calculate balance hrs according ur formula
And print this field on layout.

BOL MAHA