Forum Discussion
Measure with two different columns
Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.
i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.
i think calendar table can bring out the corresponding data from both tables. could you pls provide some sample data on this?
I'm not sure if this is what you mean by sample:
I want to divide this value by the value in the table below. They are both connected to a calendar table with a many-to-one relationship.
Yes, that's kind of sample data. However, you can simplify that and not the screenshot. It's very hard for us to create the solution based on the screenshot. You can just paste some data in the reply. At last, pls let us know what the result you want to get based on the data you provided.
i just created some simple data and provide a solution. pls see the attachment and check if this is what you want.
you are welcome