Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

find first value

I have the following two tables: Order and OrdLn I would like to find OrdLn[Price] where OrdLn[OrdNo] = Order[IDBakssystem] and OrdLn[ProdNo] = "TS-L" and store it in an calculated column TS-L in t...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    This has been solved by correcting the data in the database, eradicationg the original problem.

     

    Thank you very much for your assistance!

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous  Please post the sample test data (that can be copied easily) and expected output to suggest an accurate solution.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

OrdLn

OrdNoProdNoPrice
73013TS-L8000
73013TS-L0
7301310300000390,456
73013T40
73013T40
73013T40
73013TS-L0
73013 0

 

However with the formula I thought worked, it still returns 0 not 8000.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thank you for the reply!

       

      I have an Unique column "LnNo", and I suppose I could use the lowes denominator there as it would be the highest probability to be correct, however not guaranteed.

       

       

      • v-danhe-msft's avatar
        v-danhe-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        7 years ago

        Hi Anonymous ,

        Ok, if your problem could be solved, don't forget to close this topic.

         

        Regards,

        Daniel He