Forum Discussion

Chris2B's avatar
Chris2B
Icon for Helper I rankHelper I
2 years ago

Date tables - Sage 200

Hi I need somehelp with my date table. I have a live dataset that has been integrated from Sage 200, however I am having a major issue with my date table. It is pulling all the way from 1818 inste...
Need Help
Tutorial Requests
Chris2B's avatar
Chris2B
Icon for Helper I rankHelper I
2 years ago

I've corrected the Max in line 18 and it coes up with this, how I simplyfy it?

 

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Why did you change line 26?    needs MAX, not MIN.

 

At this point it might be easier if you would provide a sample of your data model and data.

  • Chris2B's avatar
    Chris2B
    Icon for Helper I rankHelper I
    2 years ago

    Sorry it must have been a typo.

    I have corrected it and it is still giving me the same message.

    thi is the model as it was pulled directly from Sage 200, it is very messy and that is why I am having troubles with it.

    I have managed to do basic sales and costs calculations but I am unable to make any time calculated measures.

     

    THis is what the model view looks like, what sample data would you like?

    :