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

Question

Question

how to do a difference of 2 fields in forms 10 , the reverse of a sum

Forms Version 10
Updated February 29, 2016
asked on February 23, 2016 • Show version history

Hi guys,

 

I tried to calulate the difference between to number fields

 

= field1 - filed2

=(filed1 - field2)

I also tried

=SUM(field1, -field2)

 

And no one worked

 

Got error.

 

What is the good formula syntax to do this with the new feature in Forms 10

 

0 0

Answer

SELECTED ANSWER
replied on February 23, 2016

The error message that you receive is implying that you are trying to calculate two fields within the same table row. Is that correct? If so, Forms 10 currently does not support that ability, but it should be coming in the next update.

0 0
replied on February 23, 2016

on the same line.

it works if I do a =SUM(field1, field2)

 

No error

 

What I want to do is to get  QTY Missing = QTY - QTY Rec'd on the same line

 

If I do a SUM it works , so I do not understand why it works for sum but not for a difference

0 0
replied on February 29, 2016

Hi there,

Table row level calculation will be supported in the upcoming new version of Forms in.

0 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.

Details
Related Posts
Loading ...