Forum Discussion
mlsx4
Memorable Member
Memorable MemberProblem 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 ...
sergej_og
Super User
Super UserHey 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?
mlsx4Memorable Member
Memorable MemberHi 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 😊