I'm getting nulls when i created YTD sales, and a blank graph due to the nulls from the YTD Sales. The IF statement below is what i used, and i don't know if I'm missing something.
code:
IF YEAR ([Order Date]) = YEAR (TODAY()) then [Sales] END
I'm getting nulls when i created YTD sales, and a blank graph due to the nulls from the YTD Sales. The IF statement below is what i used, and i don't know if I'm missing something.
code:
IF YEAR ([Order Date]) = YEAR (TODAY()) then [Sales] END
Copyright © 2021 Jogjafile Inc.