Have to group rows by calendar quarter based on [Actual Start] date. Am trying virtual column
CONCATENATE(YEAR([Actual Start]),“Q”,CEILING(MONTH([Actual Start])/3))
but MONTH([Actual Start])/3 is giving me an integer.
Example 1/15/2019 computes to Month = 5.000
but am getting
MONTH([Actual Start])/3 = 1.000 , not 1.667
I want 5/3 = 1.667 so I can get Ceiling = 2
Use MONTH([Actual Start])/3.0
Fix for expression giving 0% or missing decimal part Tips & Tricks ?
Trying to divide two numbers to get a percentage but always getting 0? Trying to divide two numbers but losing the numbers after the decimal point? TRY THIS Convert one or both of the values in your division expression to a Decimal value, either by: (1) wrapping the value in the expression with the DECIMAL() function; (2) multiplying the value in the expression by 1.0; or (3) changing the column’s type to Decimal if suitable to the app. FOR EXAMPLE If computing a percentage from two Number co…
That works! Thanks.