The expression below is not returning the result I expect.
=IIf(IsNull([MATERIAL]),"Select Material",([Height]*[Width]*[Length]/1000000000)*[QUANTITY])
Height = 140
Width = 150
Length = 1200
Quantity = 5
The result should be 0.126 but it's returning 10.2858
Any help appreciated.
Thank you
=IIf(IsNull([MATERIAL]),"Select Material",([Height]*[Width]*[Length]/1000000000)*[QUANTITY])
Height = 140
Width = 150
Length = 1200
Quantity = 5
The result should be 0.126 but it's returning 10.2858
Any help appreciated.
Thank you
Last edited: