Forum Discussion
Solved
Delta Calulation
Dears, I created a smal table with Inv Real / Bdg Real / Delta than i used to following formula to populate the matrix : Price Per table2 = IF ( HASONEVALUE ( 'Index per inv/bdg'[Inv ...
Figured out the issue by myself, the formlas started workign after cutting the relationship between the 2 tables.
Just to add this is how the table looks like Inv Bdb
Inv Bdb
| Inv 22/23 |
| Bdg 22/23 |
| Delta |
And this is linked to a database and the price has the following formula
Price US$/TN = divide(sum(Invoicing),sum(tons))
THanks