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 Bdb] ),
SWITCH (
VALUES ( 'Index per inv/bdg'[Inv Bdb] ),
"INV 22/23", [Price US$/TN],
"BDG 22/23", [Price Bdg US$/TN],
"Delta", [Price US$/TN]-[Price Bdg US$/TN]
),
0
)
THe Real and Bdg Price works fine but the delta is not showing anything
I suppose i need to use a calculate function to calculate this part ?
Any support will be highly apreciated
Alex
Figured out the issue by myself, the formlas started workign after cutting the relationship between the 2 tables.
3 Replies
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
Sorry, having trouble following, can you post sample data as text and expected output?
Figured out the issue by myself, the formlas started workign after cutting the relationship between the 2 tables.
