Question

To_Date Function When Date Field is a Quarter

  • 3 August 2022
  • 0 replies
  • 16 views

I am trying to find the dollar variance between two quarters. When I have my date field in months in a pivot, I can easily use the “to_date” function in combination with pivot_where to calculate the variance between two months. However, when I go to roll this up to the quarter, it seems like the “to_date” function does not recognize quarters. Help resolving this would be much appreciated. I am not sure if I need to use another function?

 

pivot_where(
  (to_date("2022-Q2")=${MYTABLE.report_quarter}),${REVENUE})


0 replies

Be the first to reply!

Reply