Just a couple of queries when using aggregates, I don't appear to be able to:
1) ..give the field an independent label and style. I see that I can use a pseudo style attribute, but doesn't that then effect both the 'text' and the value?
2) ..to have multiple values for a single column. IE I do not appear to be able to have a count and a sum on a column as it seems to expect the AGGREGATE to be directly below the table column.
3) ..to have an aggregate on a non-EDIT field as the compiler rejects the field the aggregate is attached to. I can follow that normally, apart from in the case of a COUNT or PROGRAM type.
+1 from me
I raised similar issues during the EAP on the back of a "Hidden attribute for aggregate" question from Snorri Bergmann. The feature could do with being more general as far as attributes, position, multiple aggregates etc.,
but I don't think it's viewed as a high priority.Julian
In order to get a higher priority, the developers need the feedback from the user-base.
In the case of ...
2) ..to have multiple values for a single column. IE I do not appear to be able to have a count and a sum on a column as it seems to expect the AGGREGATE to be directly below the table column.
... I raised that internally when I first saw the first screenshots in May last year, I raised it again in October when I was in Strasbourg seeing the new features in the new flesh before the EAP, and then again in the EAP itself, myself, Julian, and Tim Sodowsky commented or +1.
I reckon every 4gl/Genero site I have been to over the years has had a screen like the third one below with totalling on a column showing Nett, Tax, Gross totals, and a developer has asked how they can align these totals with the column. However only myself, Julian, Tim, and now Steve will be down as requesting that feature.
Below is an extract of my mail from the EAP. If you have screens like the following where the new AGGREGATE functionality won't meet your needs then make sure your voice is heard. I can't promise anything, I'm too far away from the action, but a request with lots of requestors is more likely to be considered than one with no requestors,
Below are some cases I don't think the current implementation can't handle, but to date apart from your brief comments in b) and c), no-one has raised in the EAP. So if you or anyone else do have a 'use case' that you can't handle with the new functionality, but you would expect that you would be able to, then this EAP is the place to raise it.
Similarly if anyone agree or disagree with something, rather than silently nodding or shaking your head, make your opinion known. Even if it is a simple email that says +1. I can't promise it will be implemented but the more input we have the better decisions we will make.
Reuben
-- Input to total fields, as used in a Quotes Entry Screen, (or as you called it goal seeking)
-- Salesman can enter the Quote value (f07), and have the system calculate margin for each line
-- Salesman can enter the Quote margin (f06), and this will be applied to each line
-- Salesman can enter override price (f03) or margin (f04) for each individual line.
Product Qty Price Margin Value
[f01 |f02 |f03 |f04 |f05 ]
[f01 |f02 |f03 |f04 |f05 ]
[f01 |f02 |f03 |f04 |f05 ]
[f01 |f02 |f03 |f04 |f05 ]
Total [f06 |f07 ]
...
EDIT f04 = fomronly.margin, COMMENT = "Enter the desired quote line margin percentage"; EDIT f05 = formonly.line_value, COMMENT = "Enter the desired quote line value"; EDIT f06 = formonly.quote_margin, COMMENT="Enter the desired overall quote margin percentage"; EDIT f07 = formonly.quote_total, COMMENT="Enter the desired overall quote total";
-- Opening balance and a running total
-- Summary line at top with an opening balance
-- A list of transactions and a running total in a column
Date Transaction Value Balance
(Opening)[f00 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
...
LABEL f00 = formonly.opening_balance;
LABEL f04 = formonly.running_balance;
-- More than one Summary Line
Product Qty Price Value
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
Delivery Charges[f05 ]
Net Total [f06 ]
Tax [f07 ]
Gross Total [f08 ]
-- More than one summary line, additional fields to the right
Product Qty Price Value
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
[f01 |f02 |f03 |f04 ]
Total (Invoice Currency) [f05 ][c05 ]
Total (Home Currency) [f06 ][c06 ]
LABEL f05 = formonly.invoice_total; -- Value of invoice in invoice currency LABEL f06 = formonly.home_currency_total; -- Value of invoice in home or base currency LABEL c05 = formonly.invoice_currency;-- Currency of invoice LABEL c06 = formonly.home_currency; -- Currency of sales ledger
Sign in for full access
Help
