Forum Discussion

Chris2B's avatar
Chris2B
Helper 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
Helper I
2 years ago

I have tried using Chat GPT to amend the Max values and I have gotten a new error message:

 

 

lbendlin's avatar
lbendlin
Super User
2 years ago

that would be in line 18. 

 

Your overall formula looks like it can be simplified too.  Can you formulate the business rules for earliestdate and latestdate?

  • Chris2B's avatar
    Chris2B
    Helper 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
      Super 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
        Helper 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?

        :