Display quarterly results

Something like:

let q := yearquarter(Today());

sum((select Kosten where yearquarter(Factuurdatum) = q).Bedrag)

Steven

ps: using yearquarter() instead of quarter() gives you only the results of the current year and not the past years.

To build on Steven's comments, if you have a formula field called quarter that has:

quarter(Factuurdatum)

Then you can find all quarter 1 records regardless of year by using:

sum((select Kosten[quarter = 1]).Bedrag)

the square brackets are another way of doing a where statement.

The formula is working exactly like Steven said it would, see his ps comment.

If you want to create a formula that finds the current year quarter 1 then you can change either:

let q := 1; <- change the value of the variable used in the select statement

sum((select Kosten where yearquarter(Factuurdatum) = q).Bedrag)

or

(remove the variable assignment)

sum((select Kosten where yearquarter(Factuurdatum) = 1).Bedrag) <- hard code the quarter number into the select statement

Yes, sorry. I was thinking quarter not yearquarter. Give it a try and let us know.

Jarno,

I would create a choice field (in this example called Kwartaal) with 4 choices in order Kwartaal1,Kwartaal2,Kwartaal3 en Kwartaal4. With this, you can choose which quarter you want to show. The formula would then be:

let q := Kwartaal;

sum((select Kosten where year(Factuurdatum) = year(today()) and quarter(Factuurdatum) = q).Bedrag)

Steven

Jarno,

Verdere Hulp nodig? Contacteer mij gerust. Mijn gegevens zijn te vinden in de Partner Pagina.

Steven