When the fiscal period reporting got implemented, why didn't the Fiscal Quarter and Fiscal Year get added as standard calculated properties on Deals? I want to group and filter deal views based on 'This Quarter', or 'This and next quarter', etc. I also want to include Quarter as a column on the list view so I can export deal views to fuel offline reporting. Ideally sorting on the column for Quarter understands time sequence properly. Ideally, the definition of what the fiscal period looks like would be a customization feature on the Deal Settings tab, e.g. YYYY-Q# vs Q#-YYYY, defining 4-4-5 (financial periods) vs more standard/evenly distributed periods like Q1=Jan-Mar, Q2=Apr-Jun, etc. I guess for now, I have to create a custom calculated property. Oh but the calculated property is so limited, it doesn't support functions for OR, AND, CASE, so I can't say something like If (or (month(close date)=1, month(close date)=2, month(close date)=3) 1, or (month(close date)=4.... So Plan A: added Fiscal Period as a standard calculated property, or Plan B: make calculated properties more powerful by adding functions for OR, AND, CASE and enable the calculated property to result in a text string that can be a concatenated result like: concatenate(year(close date),"-Q2")
...read more