Forum Discussion

jk8979356's avatar
jk8979356
Regular Visitor
5 years ago
Solved

How do I reference a specific cell value from a 2nd table inside of a formula on a different table?

I have a table that has the following formula:   = Table.AddColumn(#"Changed Type2", "Qty Forecast", each if [Quantity] <= 0 then [Quantity] else ([Quantity] / (List.Sum(#"Changed Type2"[Amount]) ...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    jk8979356 , so you may use

     

    = Table.AddColumn(#"Changed Type2", "Qty Forecast", each if [Quantity] <= 0 then [Quantity] else ([Quantity] / (List.Sum(#"Changed Type2"[Amount]) / #"2020forecast"{0}[column2])))

     

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, jk8979356 , you may use 

= Table.AddColumn(#"Changed Type2", "Qty Forecast", each if [Quantity] <= 0 then [Quantity] else ([Quantity] / (List.Sum(#"Changed Type2"[Amount]) / forecase[column2]{0})))

or equally

= Table.AddColumn(#"Changed Type2", "Qty Forecast", each if [Quantity] <= 0 then [Quantity] else ([Quantity] / (List.Sum(#"Changed Type2"[Amount]) / forecase{0}[column2])))
  • jk8979356's avatar
    jk8979356
    Regular Visitor
    5 years ago

    Thanks for the help. When I add that I get the following error:

     

    If I open it in the Advanced Editor, it doesn't show the full error:

    Any ideas?

     

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      5 years ago

      jk8979356 , what's the name of the query where you extract the number?

      • jk8979356's avatar
        jk8979356
        Regular Visitor
        5 years ago

        The query name for I extract the number is "2020forecast"