Help with expression

[Anonymous]

Hi guys,

I have two tables:

• Sales
• Returns

These two tables cannot be joined but I would like to write an expressions which is something like the sum of sales where sales customer matches the return customer number.

This would then allow me to have a sales value versus returns value within the same straight table.

Can this be done?

I hope this make sense?!!

[Anonymous]

Hi Jamel,

Just for a better understanding, why cant you join the 2 tables?

[vishsaggi]

Join your sales and returns on your customer number this way the flow will be smooth when you use any chart objects. Any specific reason of not joining?

[Anonymous]

I've got a master calendar, so when i try to do a join this cause loops..

[el_aprendiz111]

Hi

You could share a sample of data.

[vishsaggi]

Can you share a snapshot of your data model?

[Anonymous]

Don't worry about this one guys.  I will try and tackle it a different way.

I thought there was something which you can do in an expression but I am guessing there isn't.

Thanks

[vishsaggi]

We can try if you can share some sample data with an expected output? Without looking at the data it is kind of tough to give you any advice.

[rubenmarin]

This kind of situations most of the times can be solved concatenating fact tables (sales and returns).

A snapshot or some kind of guide about the model will be need to provide more accurate answer.

[Ricardo_Gerhard]

Dear Jamel,

   Below, some samples how to implement master calendar table:

Master Calendar Generation Script‌

The Master Calendar‌

Use of Master Calendar