You’re offline. This is a read only version of the page.
40
How can I make the Extended Price and Extended Cost in Excel Report Builder come out as a negative amount for Returns? I'm using the SalesLIneItems table only. In Set Field Options nothing appears in the dropdown of Field.
*This post is locked for comments
You might need to use calculated field with SQL CASE to acheive this, let me know if you need help in the Syntax.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (