10 Replies Latest reply: Mar 21, 2016 6:22 AM by Pradeep Kumar Pandey RSS

    Canonical Date Expression

    Pradeep Kumar Pandey

      Hi All

       

      I have two dates Start_Date and Completed_Date and I am using canonical date in my data model. My question is how to write a set expression to calculate amount for a selected period. Say user has selected period start as 05/05/2015 and period end as 15/05/2015.

      What should be my set analysis to sum the amount based on the Start_Date and sum of Size based on the Completed_Date.