Zoran Zivkovic wrote:

> --- In firebird-support@yahoogroups.com, John vd Waeter <john@...>
> wrote:
>
> I tried to debug query, and when it brakes, it always brakes on the
> same GROUP BY value, and it is value which is always with bigest
> result.
>
> Therefore, the dates are OK (I tHink), it is question how to reduce
> number of decimals in result set(again my opinion).
>

Right, I cannot look on your screen... so just ruling out...

What if you change

Sum(I_CENA*I_KOL*(1-(F_KASP/100.00))*((100-I_RAB)/100)) AS VP

into

Sum(I_CENA*(I_KOL*(1-(F_KASP/100.00))*((100-I_RAB)/100))) AS VP


??