3 Replies Latest reply: Aug 17, 2015 12:07 AM by jagan mohan rao appala RSS

    Formula on both sides of the expression in the expression editor



      I have 3 columns: bdate, camnt and ramnt. I am trying to calculate the MTD sales based on these values.


      sales = (camnt - ramnt)


      However bdate is in a different format and requires a formula to be converted to date format:


      bdate1 = date(floor(bdate/ 86400 + 25569))


      Now my MTD expression looks something like this:


      Sum({<$(=date(floor(bdate/ 86400 + 25569))) = {">=$(=MonthStart(max(date(floor(bdate/ 86400 + 25569))))) <=$(=(max(date(floor(bdate/ 86400 + 25569)))))"}>} (camnt-ramnt))


      However, all I get is the sales for that particular date which I have selected and not the cummulative sales of that month till that date. Can someone please tell me what am I doing wrong here?