Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please can someone point out where I'm going wrong with the below syntax.
It should be straight forward but I'm obviously missing something as I'm getting an "Invalid Expression" error, but no indication to why. All fields exist in the "QuoteInfo" table.
Cheers
Chris
Load upper("QLI_Ar-entity") & '|' & upper("Quote No") & '|' & upper("Quote Version No") as "QuoteKey",
"QLI_Ar-entity",
"Quote No",
"Quote Version No",
"QI_Quote-status",
SUM("QLI_calc-gross" * "QLI_Qty-orig-quo") as QuoteTotalGross,
SUM("QLI_calc-net" * "QLI_Qty-orig-quo") as QuoteTotalNet
Resident QuoteInfo
GROUP BY "QLI_Ar-entity","Quote No","Quote Version No";
Spotted it the second I posted this question, I wasn't including "QI_Quote-status" in the group.
Thanks
Chris
Corrected:
Load upper("QLI_Ar-entity") & '|' & upper("Quote No") & '|' & upper("Quote Version No") as "QuoteKey",
"QLI_Ar-entity",
"Quote No",
"Quote Version No",
"QI_Quote-status",
SUM("QLI_calc-gross" * "QLI_Qty-orig-quo") as QuoteTotalGross,
SUM("QLI_calc-net" * "QLI_Qty-orig-quo") as QuoteTotalNet
Resident QuoteInfo
GROUP BY "QLI_Ar-entity","Quote No","Quote Version No","QI_Quote-status";
Spotted it the second I posted this question, I wasn't including "QI_Quote-status" in the group.
Thanks
Chris
Corrected:
Load upper("QLI_Ar-entity") & '|' & upper("Quote No") & '|' & upper("Quote Version No") as "QuoteKey",
"QLI_Ar-entity",
"Quote No",
"Quote Version No",
"QI_Quote-status",
SUM("QLI_calc-gross" * "QLI_Qty-orig-quo") as QuoteTotalGross,
SUM("QLI_calc-net" * "QLI_Qty-orig-quo") as QuoteTotalNet
Resident QuoteInfo
GROUP BY "QLI_Ar-entity","Quote No","Quote Version No","QI_Quote-status";