Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dears,
I created a smal table with Inv Real / Bdg Real / Delta
than i used to following formula to populate the matrix :
Solved! Go to Solution.
Figured out the issue by myself, the formlas started workign after cutting the relationship between the 2 tables.
Figured out the issue by myself, the formlas started workign after cutting the relationship between the 2 tables.
Sorry, having trouble following, can you post sample data as text and expected output?
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
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |