Skip to Content

Complicated IDT calculation

Hi guys

I have two derived dates in my IDT as below:

Date 1:

TRUNC(DIM_DATE.CALENDAR_DATE,'MONTH')

Date 2:

MAX(DIM_DATE.PAYMENT_DATE)

I need to do a 'month between' for these two dates but IDT gives an error saying 'Not a single group by' function... any ideas how to resolve this?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 20, 2016 at 10:27 AM
    Add comment
    10|10000 characters needed characters exceeded