is there any solution for this kind of calculation

[PERMADI]

Hi

I want to ask whether it is not possible to use a formula like this?

[AleksiAlkio]

Yes it is if the "Material" and "Vol No 1" are using proper column types. Though you need to use LOOKUP([_THISROW].[Iten No 1],...)