I know it must be simple but missing a logic somewhere to get show Last Day of Quarter of a year.
I have Quarter formula to show "Q1,Q2, Q3 and Q4" and wanted to show Last of day of each quarter.
= "Q" + FormatNumber( Floor((ToNumber( [Fiscal Month])- 1)/3)+1; "0")
Tried Todate but getting an #Error.
Appreciate any help.