1 Reply Latest reply: Oct 5, 2017 10:29 AM by Jessie Sauer RSS

    LY variable not working

    Jessie Sauer

      Hi, I created a variable for CYTD revenue that works correctly:

      Sum({$<[%dateflag_$1]={1}, [%dateflag_CYTD]={1}, $(vExcludeDateFields)>}  [Transaction Line Gross Amount])

       

      However, when I try to replicate this for LY revenue it is showing incorrect data:

      Sum({$<[%dateflag_$1]={1}, [%dateflag_LY]={1}, $(vExcludeDateFields)>}  [Transaction Line Gross Amount])

       

      I noticed that the LY variable appears to be summing all revenue from LY through the current year. Any ideas as to what I need to do? Thanks