I've searched the forum, sorry If it's answered before
Here's what I'm trying to do:
SELECT
[LPA_e2].Quantity
sum(Case When u.System = 'Metric' then [LPA_e2].Quantity else [LPA_e2].Quantity * u.BaseMultiplier End) as [TotalQuantity]
FROM ....
llblgen 2.0, not possible in this version? Fine, how can I do this then:
SELECT
[LPA_e2].Quantity
Case When u.System = 'Metric' then [LPA_e2].Quantity else [LPA_e2].Quantity * u.BaseMultiplier End as [Quantity]
FROM ....
