Dashboard Prompt
Dear All,
Currently I have put a formulae for modified date field as CASE Opportunity."Current Sales Stage" WHEN 'Prospect' THEN Opportunity."Modified By Date/Time" WHEN 'Approach' THEN Opportunity."Modified By Date/Time" WHEN 'Negotiation' THEN Opportunity."Modified By Date/Time" WHEN 'Closure' THEN Opportunity."Modified By Date/Time" WHEN 'Order' THEN Opportunity."Modified By Date/Time" ELSE CAST(null as DATE) END and close date field CASE Opportunity."Current Sales Stage" WHEN 'Closed/Won' THEN Opportunity."Close Date" WHEN 'Closed/Lost' THEN Opportunity."Close Date" ELSE CAST(null as DATE) END
Now my main query is that currently I have build a dashboard prompt where the same formulae has been put on edit formulae button for modified date and close date but the filter does not work.Could you tell me if its right to put a formulae on this or we have to use a presentation variable.
Currently I have put a formulae for modified date field as CASE Opportunity."Current Sales Stage" WHEN 'Prospect' THEN Opportunity."Modified By Date/Time" WHEN 'Approach' THEN Opportunity."Modified By Date/Time" WHEN 'Negotiation' THEN Opportunity."Modified By Date/Time" WHEN 'Closure' THEN Opportunity."Modified By Date/Time" WHEN 'Order' THEN Opportunity."Modified By Date/Time" ELSE CAST(null as DATE) END and close date field CASE Opportunity."Current Sales Stage" WHEN 'Closed/Won' THEN Opportunity."Close Date" WHEN 'Closed/Lost' THEN Opportunity."Close Date" ELSE CAST(null as DATE) END
Now my main query is that currently I have build a dashboard prompt where the same formulae has been put on edit formulae button for modified date and close date but the filter does not work.Could you tell me if its right to put a formulae on this or we have to use a presentation variable.
0