Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Data Update Error (Adds the data many times)

Hi everyone, I need to raise the following topic, as I have not been able to find the solution to my problem. I tell them to develop a financial model, which considers the budget for the year. The c...
lbendlin's avatar
lbendlin
Super User
2 years ago

Your parameters look good. Now show the query where you use them.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Exieten queries based on SQL connection and excel file

Both consultations were consolidated and annexed in a sheet called consolidated

Now the report in the web service throws me

January, it adds two months to the values, February gives it to me correctly and from March to December it doesn't give me values.

In summary, the information in ppto 24 is only read for the months of January and February (January adds the values twice and February correctly)

Filter from March to December

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Your filter is wrong. Only RangeStart should be inclusive. RangeEnd must be exclusive.

     

    each [RefDate] >= RangeStart and [RefDate] < RangeEnd

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      Change and review the filters, [RefDate] >= RangeStart and [RefDate] < RangeEnd

      And now the result is that January is right

      But from February onwards I don't get any information from PPTO 24

      Could it be related to the fact that I don't have data as real 2024?