Hi all,
I have a requirement of dividing 12 months in current year into 4 quarters.
Can anyone help me with it?
Discussion posts and replies are publicly visible
you can do like this by using custom record fields in record type
Thank you It worked.
Great
Use this
trunc((month(local!date) /3),0) +1
This type of expression is a little more flexible as it will work for non-standard quarters (i.e. Jan-Mar = Q4)
a!match( value: month(ri!date), whenTrue: fv!value <= 3, then: 4, whenTrue: fv!value <= 6, then: 1, whenTrue: fv!value <= 9, then: 2, default: 3 )
You can also replicate this logic in a Custom Record Field using https://docs.appian.com/suite/help/24.1/fnc_crf_customfieldmatch.html
HI, if you want to devide the "Year" In "Quarters" based on "Dates", here is the way to do it:
if( isnull(rv!record['recordType!{4d75e90b-cfa1-4109-8430-d517fc558bbb}MMS Meeting.fields.{2e6f1ac9-328d-44df-bf3a-93cc8f6bab07}startDate']), null, /* Quarter: Concatenate Q and the quarter number */ "Q" & floor((month(rv!record['recordType!{4d75e90b-cfa1-4109-8430-d517fc558bbb}MMS Meeting.fields.{2e6f1ac9-328d-44df-bf3a-93cc8f6bab07}startDate'])-1)/3) + 1 /* Year: Concatenate year */ & " " & year(rv!record['recordType!{4d75e90b-cfa1-4109-8430-d517fc558bbb}MMS Meeting.fields.{2e6f1ac9-328d-44df-bf3a-93cc8f6bab07}startDate']) )
INPUT VALUES:
OUTPUT: