You are viewing limited content. For full access, please sign in.

Question

Question

table field calculation with other field

asked on March 9, 2020

Hello,

I have all Single Line fields 1, 2 &3

I want that field 3 should show the difference of 1 & 2, the only issue is that field 2 is in table.

The table has only one row & that's static.

 

Can someone please help?

0 0

Answer

SELECTED ANSWER
replied on March 9, 2020 Show version history

Hi Sonia!

Not all calculations are available for fields inside of tables. Here's an easy way to accomplish what you need.

Go to the field where you want the total to be and open up the advanced tab. In the calculation field, enter the following:

=SUM(MINUS(VALUE(INDEX(TABLE_NAME.COLUMN_NAME, 1))), VALUE(SINGLE_LINE_VARIABLE))

Make sure you replace TABLE_NAME.COLUMN_NAME and SINGLE_LINE_VARIABLE with the correct variables using the variable picker. 

Because you're using single line fields, you'll need to use the VALUE function to get the numerical value from the fields. 

For a list of formulas that work in tables and lists, check out this help center article and scroll down to "Functions for Tables and Lists"

Let me know if this works!

0 0
replied on March 9, 2020

Perfect!

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.