Calculate two fields in Sharepoint list
Calculated column in sharepoint list
please follow the steps:
1. Create three columns Quantity, Unit Price & Net Amount
2. Columns types: Quantity [Number], Unit Price [Currency], Net Amount [Calculated (Calculation based on other columns)]
3. While creating Net Amount Column give text which is quotes (avoid quotes) “=[Quantity]*[Unit Price]“
Comments
Comment from G Vijai Kumar
Time August 11, 2010 at 2:04 pm
@Paul Elksnis: Does the two pages exists in the same site or different sites? please confirm
Comment from Paul Elksnis
Time July 21, 2010 at 4:09 pm
Hi – I’m trying to create a calculate column on my page – but the unit cost is located on another page in sharepoint. Is there any way to reference that other page or can you only use the calculate field if the unit and the number of units are both on the same page?
thanks
Paul