Forum Discussion

Romesss31's avatar
Romesss31
New Member
1 year ago
Solved

Multiplication fonction year between two tables

Hello All,

 

I would like to multiply two tables depending on each year.

For example, I have a first table :

202401/20241
202402/20242
202403/20243
202501/20254
202502/20255
202620266

 

And a second table:

202410
202520
202630

 

I have a relation between both table with the year as reference.

 

I would like to create a global measure who permits to multiply correct value by year.

In this example, the result of the measure should be 420.

 

Can you please help me to find the correct measure please ?

 

Thank you very much for your help and have a nice day,

R

2 Replies

    • Romesss31's avatar
      Romesss31
      New Member

      Hello Ibendlin,

       

      Thank you very much for your answer.

      With a relation 1 to * between both table, this formular is working.

       

      Have a nice day,

      R