Hey. So recently due to comments from support, I was asked to de-normalize my data model. I did so, but now the values are breaking. When I have $ Cleared and $ Posted in my table -it inflates the cleared amount by many many times (pic1). When I remove Poster filter in $ Posted field, the amount returns to normal (pic2).
The de-normalization is structured to have a user_id in the main table. This user id points to another table called
Poster
. The user values in main table can either exist or they can be null. How do I go around this issue?