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!

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        I'll try it out in the upcomming days, and post the result.

        Thank you for your assistance!