Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LY variable not working

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

1 Reply
Not applicable
Author

Also, LYTD works fine too:

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