Skip to main content
Question

Quaterly summation of a value

  • November 24, 2025
  • 1 reply
  • 39 views
emre
Contributor
Forum|alt.badge.img

Hi All, 

I have the following set up where / separate's attributes - where Value X and Y can exists multiple times within a month linked to the Item ID.

Place / SubPlace / itemID / Year / Month / YYYYMMDD / ValueX / ValueY /  SUMXPlace / SUMXSubplace / SUMYPlace / SUMYSubplace /

What i would like to do is after i have the sum per month per place and subplace, is to see the sum again of these sums on a quarterly basis - ie. Jan-Mar = Q1, April-June = Q2.

So the final table would be something along the lines of this - to still allow filtering per place/subplace/quarter

Place / SubPlace / Quater / QSUMXPlace / QSUMXSubplace / QSUMYPlace / QSUMYSubplace /

Any ideas or help would be greatly appreciated!

/Emma

 

 

1 reply

hkingsbury
Celebrity
Forum|alt.badge.img+67
  • hkingsburyCelebrity
  • Celebrity
  • November 27, 2025

You could convert the month name, to numeric (Jan = 1, Feb = 2…. etc) then divide that by 3, and get the ceiling of that value

@Evaluate(@ceil(@Value(date_numeric)/3))

This will then give you what quarter each month is in, and you could use that value as the group by for a statistics calculator

alexbiz
DanAtSafe

Community Stats

32,213
Posts
122,321
Replies
39,902
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.