Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Also, LYTD works fine too:
Sum({$<[%dateflag_$1]={1}, [%dateflag_LYTD]={1}, $(vExcludeDateFields)>} [Transaction Line Gross Amount])