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

Question

Question

Built-in forms calculation with condition

Updated July 28, 2017

asked on July 28, 2017 • Show version history

I have table set as displayed in the the attached image.

I need to fill Year 1 or Year 2 with the Cost value for each row, based on the selection of the Condition column.

I'm trying and failing to return a result. Here's my current equation in the Year 1 function field

=IF(INDEX(Table.Condition,Row())!=2,=INDEX(Table.Cost,ROW()),0)

Any suggestions?

Table _ Laserfiche Forms.png

conditions_ Laserfiche Forms.png

Table _ Laserfiche Forms.png (4.44 KB)

| Download

conditions_ Laserfiche Forms.png (5.78 KB)

| Download

0 0

Replies

replied on July 28, 2017

I figured it out, this worked, in case anyone else finds it helpful.

First, I switch the assigned values in the Condition to: Year 1=1, Year 2=3, Both=2

Then in Year 1:

=IF(INDEX(Table.Condition,ROW())<3,INDEX(Table.Cost,ROW()),0)

Then in Year 2:

=IF(INDEX(Table.Condition,ROW())>1,INDEX(Table.Cost,ROW()),0)

0 0

You are not allowed to follow up in this post.

Sign in to reply to this post.