Skip navigation

Table Calculation

score 1
You have not voted. Active

Hi All,

 

I need to do table calculation for the below

 

  

ItemsAmount
Furnitute         45,000
Table         50,000
Cot         25,000
Fan         75,000
Iron           5,000
TV           5,000
Total

    2,05,000

 

 

 

 

 

I Need to create calculation field by name calculation1, need to do the lookup for Furniture and return the amount.

 

Example

 

In Calculation1=45,000 Value need to come,

 

I am facing error in the below formula

 

lookup(Items,2)

 

Please correct the formula

Comments

Vote history