BI Publisher - MAX function broken ?
I am using BI publisher 11.1.1.6
I have the following table with two records :
SELECT * FROM MMJ2;
F1 F2
--- ----
-10 100
-5 200
I create a dataset G_1 doing a select * from mmj2
I drag F1 from G_1 to the Global Level Functions dataset and do the MAX aggregate function. F1 and F2 are number fields in the db and integers in BI Publisher.
It is returning 0 as the max for F1, it should return -5. Here is the sample XML output :
<DATA_DS>
<G_1>
<F1>-10</F1>
<F2>100</F2>
</G_1>
<G_1>
<F1>-5</F1>
<F2>200</F2>
</G_1>
<MAX_FI>0</MAX_FI>
</DATA_DS>
0