Forum Discussion
Solved
Date difference
Hi there,
I am trying to calculate the date difference, from the PRT_OPEN_TASK_ADD_DT to today...even if the field is existing in the table it is not seeing it. Can someone please advise on what I might be doing wrong here?
I found my issue, I was using a new measure option instead of a new column. That fixed my issue, thanks for responding!!
2 Replies
In a measure, you need reference an aggregation of a column, so wrap your column reference in MIN or MAX.
Pat
I found my issue, I was using a new measure option instead of a new column. That fixed my issue, thanks for responding!!
