Laserfiche Forms Calculating Indexes in tables

replied on August 1, 2019

Hi Jason,

I think I've tried something like that and the Number of Miles field just shows 0 with no calculations:

=IF(INDEX(Expenses.ODO__to,ROW())<>"",INDEX(Expenses.ODO__from<>"",ROW()),0)

0 0

View 5 previous replies

replied on August 1, 2019 • Show version history

The second part of your formula is incorrect.

=IF(INDEX(Expenses.ODO__to,ROW())<>"",INDEX(Expenses.ODO__from<>"",ROW()),0)

The extra <>"" shouldn't be inside index function.

=IF(INDEX(Expenses.ODO__to,ROW())<>"",INDEX(Expenses.ODO__from,ROW()),0)

0 0

replied on August 1, 2019

sorry just fixed it, still came out blank.

0 0

replied on August 1, 2019 • Show version history

Blank or 0?

What happens if you just use

=INDEX(Expenses.ODO__from,ROW())

0 0

replied on August 1, 2019 • Show version history

ok it works now. I had a comma "," at the end of the statement. that's why it was blank instead of a "0". but... the calculation is off:

suppose to be 250-200 = 50 miles

then 50 * .58 = 29.00

0 0

replied on August 1, 2019 • Show version history

No problem. An alternative to using two IF calculations is to wrap your entire SUB function in the IF then use an AND for the condition.

For Example,

=IF(AND(INDEX(table.column1,ROW())<>"",INDEX(table.column2,ROW())<>""),SUB(),0)

Here you get

IF Column1 AND Column2 are not empty THEN SUB

ELSE 0

0 0

replied on August 1, 2019

let me try that.... i'll get back to you if it doesn't work.

0 0

replied on August 1, 2019

ok.. a lot better. calculation works with no errors now. Thank you!

0 0

replied on August 1, 2019

no problem!

0 0

Question