Forum Discussion

mcpamintuan's avatar
mcpamintuan
New Member
3 years ago

How to Fix there errors

  1. Item Code & Profile ID = CustomerStock_Lookup[Item Code]Stock_Lookup[Item Code]&" "&CustomerStock_Lookup[Profile ID]Stock_Lookup[Profile ID]
  2. Customer Stock Code = LOOKUPVALUE(CustomerStock_Lookup[Customer Stock Code],CustomerStock_Lookup[Item Code & Profile ID],Sales[Item Code & Profile ID])
  3. Job Cost = RELATED()
Data Protection

1 Reply

  • JirkaZ's avatar
    JirkaZ
    Solution Specialist
    3 years ago

    This is really confusing. What errors do you want to fix? The formulas are weird altogether. 
    So please start with describing what the errors are and what you are trying to achieve and how your data looks like.