Quarter value as numeric numbers

MadhabikaM
Frequent Contributor

Quarter value as numeric numbers

Hi All,

 

Required a quick help in getting the quarter number as numeric format.

MadhabikaM_0-1611036769506.png

For example in attached screenshot, need to get the value for second line item as entered.

All Q1 Months should populate with numeric number 1, all Q2 should be populated with number 2 and so on....

Quartertodate() function gives a numeric number by month, but I need it by quarter.

 

Thanks

Madhu

2 REPLIES 2
Misbah
Master Anaplanner/Community Boss

Re: Quarter value as numeric numbers

@MadhabikaM 

 

See if this helps

Misbah_0-1611039063954.png

Misbah_1-1611039082705.png

MadhabikaM
Frequent Contributor

Re: Quarter value as numeric numbers

Thanks @Misbah...
That helps...