Eclipse - Reports BIRT - Aggregation

Navigation
0

Greetings, if someone works with the Reports for Eclipse BIRT plugin, I have a question about the functionality of Aggregation , its uses are not clear to me, that is to say all its potential. I know that it can be used in a table to add a field that works as an adder to others, this makes it easier to have to make specific formulas. To refresh some images here:

We see that you have the option of Function: where there is a large number of functions to use, (if you have any BIRT documentation that speaks well of this functionality I would appreciate it) and with some examples.

To the point, in this feature can I create to take the Total Amount + VAT and add it in a field? How would you do it this way, or is there another way to do it?

I do not have very clear that it goes in Expression and Filter Condition , and if I change the Function more things appear ... I'm intrigued that not taking advantage of this functionality . If I put an Expression, what is selected in Function will not matter? Is this field like to help create or is it indispensable?

    
asked by HeckDan 06.02.2018 в 13:37
source

1 answer

1

Well, I know that you can add it from the palette or Insert - Data in the field you want, you put the name , the type and there the formula , with the formula one can do what I want, but I do not use the Aggregation I think it is more specific for sum of totals, but I think that You can do the same thing by adding a "Data" where you want the result.

But better wait for someone else to confirm and expand more.

Remember that ...

The amount of Tax is:

(Amount * Percentage Tax) / 100

Example:

200 * 12/100 = 24

Then the TotalConTmpuesto is: 200 + 24 = 224

Note : note that you can not use the 12/100 = 0.12 wild card here NO it is valid to do 200 * 0.12 since the correct formula is (200 * 12) / 100

and if you want to know the Tax having the Total Amount already with it, (ie if you want to separate it) it would be:

MontoConIVA / 1. (ImpuestoPorcentaje)

Example:

224 / 1.12 = 200 (amount without tax)

    
answered by 06.02.2018 в 15:26
Enter $ value to a field and depending on the value, modify another field Select certain MySQL table rows