What is wrong with my sentence?

[#1]

=sum(If(Date(%DataID) >= (date(min({<Mes={"=max(Mes)"},Semana=>}%DataID))) , VLR_VENDA_BRUTA ))

This part works quite well when I ask for it to return me a date: (date(min({<Mes={"=max(Mes)"},Semana=>}%DataID)))

Still when I fit it inside the sentence, it doesn't work! And the sentence seems to work fine because if I paste some other date there, it returns me a SUM!

Can anyone help me on that?

Cheers!

[Anonymous]

Hi,

Try changing the sequence, like this:

=if(Date(%DataID) >= (date(min({<Mes={"=max(Mes)"},Semana=>}%DataID))) , sum(VLR_VENDA_BRUTA)

Cheers,

Henco