Forum Discussion
Problem with granularity
Hello everyone! I have a problem that I cannot figure out how to solve. Let's say I need to compute the difference between my theoretical rate and my real rate. Therefore I have a table for my ...
Hey mlsx4 ,
not sure since I have no clue how your datamodel looks like.
Show me your table with your theoretical values before and after change of values.
I don´t know how your data come in/stored in the table.
Do you have a new line for new values or is the value overwritten?
Hi sergej_og
Theoretical rates are defined in a table by just including a new line and the date they have been changed. That's why I said that it's being a headache.
Following the example, this would be theoretical rates table. For instance, in Jun-2023, category A changes its value:
CenterKey Category Theoretical rate Date
11A A 8,73 Jun-2022
11A B 18,08 Jun-2022
11A C 2,62 Jun-2022
11A A 9 Jun-2023
Thank you so much for your effort 😊