Hello, i have 2 charts, and i need to relate 3 rows on each THAT MUST BE EQUAL to add unexpected expenses, but, beacause i can have multiple expenses from the same person, i wanted to filter this by name, date and place. I createad an array on both and then a relation beteenw them, but for some reason, one of the lines is adding itself because the place is the same.
what am i doing wrong?
Your description is a little confusing. Would you mind adding a screenshot or two to help clarify?
I prefer not to.
ill try to explain.
currently i have a chart with expenses.
in order to add another expenses that weren’t expected im trying to add 1 more chart that relates the client and the inexpected expense.
i was trying to do something like: " if name+ place+date on chart 1 is equal to name+ place+date on chart 2 then add a relation", i tried to anchieve this by making an array on both charts with “name+ place+date” and then relate them on chart 1. but for some reason, it relates the info on chart 2 even if one is not true. It seems that the relation adds a “OR” situation instead of “and”.
Thank you for your help.
I’m not sure, but maybe you should be using a query column instead of a relation?
I’m just guessing…
1 Like
Oh, i complety missread your last menssage! Yes, thats how i should be doing it, thank you for your time and patience!
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.