I've an issue on calculating lookup value from other list.. I have List called "Product". in that I have column name "ProductCode"(Single line text) and "Unit Price"(number with 2 decimal). I've created a new custom list called "Purchase Form".

In that "Purchase Form" I want to have below:

  • A auto sequence column "Purchase ID" which will auto generate as "PO-15-####". The behind number will start from 2001.
  • A lookup column of "ProductCode" which will be in Choice mode.
  • A column which have "Unit Price" from another list will automatically generated when we choose the "ProductCode".
  • The main important column is "Purchased Value" which will calculate [Purchased Qty*Unit Price] and results will be in currency or number. [I will another column called "Purchased Qty"(number).]

I've tried lookup but unable to do the calculate. I need to have a workaround without using any backend commands.

Please help me to guide how to do in SharePoint 2013 or InfoPath 2013 without having workflow involved.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.