Table Calculation
1
Active
Hi All,
I need to do table calculation for the below
| Items | Amount |
| 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