openerp-india team mailing list archive

[Launchpad Bug Tracker <1002851@xxxxxxxxxxxxxxxxxx>]

You have been subscribed to a public bug:

It is very difficult made GROUP BY in TREE VIEW or in GRAPH VIEW, if field calculate from other fields.
For example we have table with following fields:
date (Date of production)
prod_qty (Total Quantity produced items)
reject_qty (Quantity of rejected items)
quality (Calculated field: quality = reject_qty/prod_qty)

If we try GROUP BY 'date' then for some date we get:

PROD_QTY = SUM(prod_qty of the same date)
REJECT_QTY = SUM(reject_qty of the same date)
QUALITY = SUM(quality  of the same date)

But for agregate QUALITY = REJECT_QTY/PROD_QTY = SUM(reject_qty of the same date)/SUM(prod_qty of the same date)
Because it no the same as SUM(quality  of the same date), need add extra code (for example rewrite function read_group())

It will be more cool if we have functional attribute for field, that
will describe custom agregate function other than SUM().

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
[6.2] Need functional attribute for group
https://bugs.launchpad.net/bugs/1002851
You received this bug notification because you are a member of OpenERP Indian Team, which is subscribed to OpenERP Server.