Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

My auto weekly inventory calculation stopped working.

I have a formula that automatically calcutes the change in inventory from one week to another.  This formula worked for several weeks until recently.  Our IT pushed an update to our Date Calendar (Di...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous ,

Does this calendar table data structure changed during this update? How do these tables relationship mapping? (e.g. cross filter direction setting, relationship key, filter effects...)

Can you please share some fake data with the same data structure for test?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous 

     

    Thank you for your reply.

     

    Yes, when the data was switched over IT re-mapped the relationships.  There very well could be a problem there.  Building out test data might be difficult but would you mind if i just messaged you the actual file?  There's nothing really discrete about it but I would prefer not posting it to the internet.

     

    Here is a screenshot of the relationships.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI Anonymous ,

      >>There's nothing really discrete about it but I would prefer not posting it to the internet.

      You do not need to share real data with us, you can try to create some fake data with same data structure to help us test on it.

      According to your snapshot, your relationship seems broken, maybe you can consider adding a temp date bridge table with unique records to help correct mapping with different tables.

      Regards,

      Xiaoxin Sheng