Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to add a formula to the script below that multiples Quantity * Sales in a fourth field named Sales Revenue. Can you help?
LOAD
ProductName,
Quantity,
Sales;
Write this
LOAD
ProductName,
Quantity,
Sales
Quantity * Sales as [Sales Revenue]
From Source
Write this
LOAD
ProductName,
Quantity,
Sales
Quantity * Sales as [Sales Revenue]
From Source