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

Question

Question

Multiplication in Forms

Forms Laserfiche Cloud
Updated June 9, 2022
asked on June 3, 2022

Hello,

I have 2 Fields:

 

1. BRUTTOGEHALT (Currency Field)

2. ARBEITGEBERValues.ALV (Number Field, in Table ARBEITGEBERValues)

 

I want a multiplication of these two fields.

I have tried : =MULT(INDEX(ARBEITGEBERValues.ALV,ROW()), BRUTTOGEHALT)

it throws error: This field contains a calculation error. References: ALV, BRUTTOGEHALT. 

in the preview 

 

This is laserfiche cloud.

 

0 0

Replies

replied on June 8, 2022

I'm on prem, not on Cloud, so it's possible there are some differences.

I just threw this example together and it worked.  This is with the Classic designer.

Is your form doing the calculations in the table like this or outside the table?

Are you using the Classic or New designer?

0 0
replied on June 9, 2022

New Designer & from table to outside field

0 0
replied on June 9, 2022

This part of your calculation: INDEX(ARBEITGEBERValues.ALV,ROW())   is basically saying, get the value from the ALV field on the same row I'm currently in, so that is why it worked in the calculation when I had it in the table.  But you mentioned your field is outside the table.  In that case, ROW() isn't going to return anything, so it won't know which ALV field to retrieve the value from.

So I think we need a litlte more information regarding what your goal is...

Are you trying to sum all of the ALV fields and them multiply by the BRUTTOGEHALT field?

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

Sign in to reply to this post.

Details
Related Posts
Loading ...