Comments
-
Hi @Aditya_Jain, Unfortunately Pfilters can't be used in this specific business case, they don't allow adding "empty" filters to the report. Let me explain with simple example: The link should open a report page filtered on field "region" set for Europe. (Pfilters can do this) There should also be a filter for field…
-
For anyone facing this problem, here's a solution. My colleague fixed and simplified the formula: CASE When ( -- Check Date is in previous quarter CASE When QUARTER(CURDATE()) = 1 and (QUARTER(`Datefield`) = 4 and (YEAR(`Datefield`) = YEAR(CURDATE())-1)) or ((QUARTER(CURDATE())-1 = QUARTER(`Datefield`)) and…
