Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What am I doing wrong?
[Min PPU]:
Load
Family,Scenario
,
[Product Name]
,
[Total Purchase Cost]
,
[Minimum Desired Quantity],
If
(([Product Name]=Previous([Product Name]) and Scenario = Previous(Scenario)),
min
([Total Purchase Cost]/[Minimum Desired Quantity]) as [MinPPU per P]))
resident
Main
order
by
Family
,Product,Scenario;
Main:
LOAD
Supplier,
Category,
[Item Name],
[Minimum Desired Quantity],
Segment,
Family,
[Article number],
[Component number],
Scenario,
[Product Name],
[Article/Component],
[Price Per Unit],
[Historical Cost],
[Total Historical Cost],
[Total Purchase Cost],
[Projected Savings],
from
blablabla;
what error is happening?
maybe the last comma just before the fronm
[Projected Savings],
from
blablabla;