I'm trying to sort by the result of the division of two of the columns of the report. I've tried to add the formula to the sorting and grouping section of the report but I have not been able to make it work
does anyone know if it's possible?
Is it possible to sort an Acumatica report by a calculated field (formula)?
294 Views Asked by DanielMoncadaZ At
1
There are 1 best solutions below
Related Questions in C#
- How to call a C language function from x86 assembly code?
- What does: "char *argv[]" mean?
- User input sanitization program, which takes a specific amount of arguments and passes the execution to a bash script
- How to crop a BMP image in half using C
- How can I get the difference in minutes between two dates and hours?
- Why will this code compile although it defines two variables with the same name?
- Compiling eBPF program in Docker fails due to missing '__u64' type
- Why can't I use the file pointer after the first read attempt fails?
- #include Header files in C with definition too
- OpenCV2 on CLion
- What is causing the store latency in this program?
- How to refer to the filepath of test data in test sourcecode?
- 9 Digit Addresses in Hexadecimal System in MacOS
- My server TCP doesn't receive messages from the client in C
- Printing the characters obtained from the array s using printf?
Related Questions in ACUMATICA
- How to save the Change Orders screen automatically
- Acumatica application version mismatch with the L100 snapshot
- How to Access PXSelectorAttribute Joined Table
- Multi-selector Selector in Acumatica
- Update an attribute based User Defined Field using Acumatica.RESTClient.ContractBasedApi
- Is there a way to override [PXCopyPasteHiddenFields] on a built in view in Acumatica?
- How do I add a row in Employee Timecard via BLC code?
- How to modify the Create Prepayment action/button on Purchase Order?
- Using Checkbox Filter in GI for an API Call Always Returning True
- Subreport to add a new page per Main report item
- Acumatica API / Appointments / LocationID cannot be empty
- TemplateNotificationGenerator with PDF File from Rapport
- different reaction between with UI and REST API
- Change Location DescriptionField attribute to pull from another DAC
- How to save custom Workspace Tiles to a Customisation Project Package?
Related Questions in ACUMATICA-KB
- How to save the Change Orders screen automatically
- How do I add a row in Employee Timecard via BLC code?
- How to modify the Create Prepayment action/button on Purchase Order?
- How can I get user fields to populate in Invoice and Memo when 'Reverse' and 'Reverse and Apply Memo' processes run
- Getting request time out error while creating Production order from sales order screen
- Is there a way to include Attributes with values (combo) to a customization project?
- How can I select a unique record in a selector if the CD is the same for both records?
- Acumatica customizing PXLongOperation's processing message (Executing. Press Cancel to abort)
- When I have Published my customization package to multiple tenant, Acumatica Bill of material Screens Entry not showing in site map table
- while hide some accumatica screen from site map getting another process error
- We want to hide some accumatica screen from site map while published our customization package
- Can I make it so an Import Scenario for Alternate IDs errors instead of creating a new Stock Item if Stock Item is not found?
- Acumatica PXProjection Issues
- Is it possible to launch a Note popup from an Acumatica report?
- Are there any established solutions to creating unlocking keys for ISV solutions / customizations?
Related Questions in REPORT-DESIGNER
- Problem with loading rdlc in report viewer
- Acumatica Report designer IF,AND, SUM formula
- Reporting services: why is there all this blank space at the start of my chart?
- RDLC/Reporting Services: Gauge inside table is cut off
- How can I access which fields are placed in a report design with Devexpress Xtrareport in C#?
- IIF Expression in RDLC report of ASP.NET project acting weird
- Pentaho cde & Report-designer source
- .NET 6 Report Designer System.Runtime.Serialization.Primivites Version 6.0.0.0 Error
- Incorrect values in array
- Show View in Telerik Report Designer
- Acumatica Report Designer Concat variable shows incomplete field
- How to add customer drop down menu in Devexpress Report Designer UI
- Word Representation of the Amount field in Acumatica In Report Designer
- SSRS Design will not let me edit
- Is it possible to sort an Acumatica report by a calculated field (formula)?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
The report engine fetch data by generating a SQL query from the report schema builder configuration. I believe the fields declared in the OrderBy clause needs to be bound (must exist in database) because of that design choice.
Note that the generated request is available from the
Tools->Trace Windowwhen executing the report: