Hope this helps
Plz Mark this answer as correct and helpful to close the thread
is calculating for each record in a database?
Simple revenue can be calculated by SalesQuanity * UnitPrice
but i want to find the Returns which can be calculated by the same formula but where SalesQuantity <0
Its best do one thing provide sample 100 rows data with random number which include negative values and provide the O/P how you want.
So that it will be easy for us to decipher the problem
1 of 1 people found this helpful
If you want for each record just remove the aggregation:
if ([Sales Quantity])<0 then ([Sales Quantity])*([Unit Price]) END
Can you please also share your expected o/p.
Rather than attaching a screen grab, you can attach the file. Use Advanced editor and add an attachment in the upper right corner of a comment.
This will be helpful for those working on your issue.
Your Solution worked