How to get Quarters in a year.

Question

Hi all, 
 I have a requirement of dividing 12 months in current year into 4 quarters. 
 Can anyone help me with it?

venkat Avuluri · Answer

1.If it's a recordtype go with Extract a Partial Date for creating a Custom record field and use this field in Queryrecordtype. More About Extract Partial Dates 
 
 2.If it's CDT You need to Manipulate data After Coming or you need to use between operator(Don't think it gives expected outputs). 
 3.instead of Multiple if's (Which is ton work) Go for a decision rule which somewhat looks like this 
 
 Call the rule, for month value pass it using month() function

Mathieu Drouin · Answer

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

How to get Quarters in a year.

Top Replies