Please help for correct expression

[deepaksharma]

Hello to all of you,


I have created an attached small sample program. In this I have created an unbound column named yarn cost in which "rate*quantity+yarn wastage percentage" figure is shown and it is working properly but the problem is that I am not able to total the yarn cost column. I am staying. Please suggest me its correct expression. Thank you.

[June7]

Try:

=Sum([Quantity]*[Rate])+(Sum([Quantity]*[Rate])*[Forms]![Cost_Sheet]![Yarn_Westage]/100)


You want numbers to align left?

[deepaksharma]

Thank you very much it is working now.
Actually I had created this small sample program which in my hurry I forgot to right side align the numeric text box.
Thank you once again.