Help with formula

[francisvandergr]

I have a formula which gives a year total from offertes.

sum({<Boekjaar = {$(=max(Boekjaar) )}>}Offerte\Offertebedrag) +

Now i want expand this formula with

Status='Open'

Can someone help me ?

Sum ({<Boekjaar = {$(=max(Boekjaar)-1)}>}Offerte\Offertebedrag) +

Sum ({<Boekjaar = {$(=max(Boekjaar)-2)}>}Offerte\Offertebedrag) +

[kaushiknsolanki · Accepted solution]

Hi,

Sum ({<Boekjaar = {$(=max(Boekjaar)-1)}, Status = {"Open"}>}Offerte\Offertebedrag) +

Sum ({<Boekjaar = {$(=max(Boekjaar)-2)}, Status = {"Open"}>}Offerte\Offertebedrag) +

Hope this will help you, If not please describe u r problem in detail.

Regards,

Kaushik Solanki