0

Function result from multiple tables

I have a formula result sub-table A that I want to multiply by a number entered on sub-table B.  I wrote the formula by clicking the field for A, "*", clicking the field for B.  I get "Invalid operator: [number]*number at line 1, column 37".  What am I doing wrong?

10 replies

null
    • Nick
    • 5 yrs ago
    • Reported - view

    field_A * field_B

    not "*"

    • Jeff_Fackler
    • 5 yrs ago
    • Reported - view

    Sure, I didn't have quotes in the formula.  Sorry for the confusion

    • Jeff_Fackler
    • 5 yrs ago
    • Reported - view

    Maybe this will help.

    2019-01-25_01-01-08_PM

    • Sean
    • 5 yrs ago
    • Reported - view

    Try number(INSTRUMENTATION.Total)... It looks like you are trying to multiply with a field that is being stored as type array.

    • Jeff_Fackler
    • 5 yrs ago
    • Reported - view

    Didn't work, same error.  Strange.

    • Jeff_Fackler
    • 5 yrs ago
    • Reported - view

    Didn't work, same error.  Strange.

    • Sean
    • 5 yrs ago
    • Reported - view

    What does it display if you just have INSTRUMENTATION.Total in the formula field?

    • Jeff_Fackler
    • 5 yrs ago
    • Reported - view

    No error; it fills in the result from that field.

    • blackie
    • 5 yrs ago
    • Reported - view

    Maybe try to convert to text before converting to a number???  

     

    number(text(INSTRUMENTATION.Total))

    • blackie
    • 5 yrs ago
    • Reported - view

    Also, what about

     

    sum(INSTRUMENTATION.Total)

Content aside

  • 5 yrs agoLast active
  • 10Replies
  • 2797Views