Skip to Content
0
Jul 12, 2019 at 04:46 PM

Last day of a Quarters in a Year in Webi

663 Views

Hi,

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.

Quarter formula:

= "Q" + FormatNumber( Floor((ToNumber( [Fiscal Month])- 1)/3)+1; "0")

Tried Todate but getting an #Error.

Appreciate any help.

Thanks,

Jothi