Forum Discussion

X3svfdB1HOjKYc0's avatar
X3svfdB1HOjKYc0
Regular Visitor
4 years ago

Trouble With Links/Formulas

I have two tables. The first table is a list of containers, charge codes and amounts. See sample table with charges totalling 1400.     The second table is a list of containers, order lines ...
X3svfdB1HOjKYc0's avatar
X3svfdB1HOjKYc0
Regular Visitor
4 years ago

Thanks for your help getting the inital table merged. This is already a big step forward. 

 

Edited and updated from earlier post. I am now getting a result that is not an error, however the values seem to be divided by the volume an extra time.

 

I could take the result and multiply it again by the volume to force the correct solution, but, is there a more elegant way to get the original formula?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi X3svfdB1HOjKYc0,

    Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng