Help with formula

francisvandergr — Mon, 26 Jan 2026 18:19:17 GMT

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 — Thu, 19 May 2011 07:16:31 GMT

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

topic Help with formula in QlikView