Forum Discussion
Formatting error with datetable - userelationship
Hi all, I have a fact table with different date types e.g. 'completed date', 'due date'. I have mapped those to a datetable and want to show a total # actions completed for the last 30days. F...
Thank you for the tip. i did change the calendarauto function to the calendar function, now the error message does not show. However no data is showing at all:
It should show 1 item in the last 30 days completed:
So now the format seems fine but the function does not work. Is the function in essence correctly set? (first time i use userelationship.
Now that you changed your date table calculation, check if the inactive relationship between it and completion date is still there
AND usually Date is Date/Time when you create with Calendar, change to Date. if not yet