3 Replies Latest reply: Sep 11, 2017 6:01 AM by jagan mohan rao appala RSS

    Current quarter - previous quarter

    mohan krishna

      Hi,

       

      I have 2 date fields & sales field in excel like below

      Quarter    Month        sales

      2017Q3    201709       10

      2017Q3    201708       20

      2017Q3    201707       30

      2017Q2    201706       40

      2017Q2    201705       50

      2017Q2    201704       60

      2017Q1    201703       70

      2017Q2    201702       80

      2017Q2    201701       90


      i want to get current quarter sales - (minus) previous quarter based on the quarter selection in front end


      if i select 2017Q2 in front end -- it shud show ((40+50+60 = 150) - (70+80+90 = 240)) '-90'


      I want "Set Expression" for this..

      how to write with functions/variables ? (not hardcoded)


      ThankYou!!