Is there a reason that an expression like this would work fine if manually put into a number of reports, but not if saved as a global expression and put into the report as a saved expression? [Invoice Date: Sum: Sales <EVAL!GetPromptValue('Reporting Currency','USD')!>] I'm doing this to allow users to choose a reporting…
Why are my account group permissions in the catalog (where you set permissions on folders with dashboards and reports) being wiped out by copyspace? My command looks something like this: copyspace fromspaceid tospaceid…
There have been changes in 2025.02 for copyspace and duplicate space (from the global navigation bar + menu). Please take a look at the KB3569756 article in ServiceNow for important information about data movement. *if there are issues with the link, open ServiceNow through Infor Portal/Concierge and search for the article.
I have two measures, [Delivery Date: Sum: Releases Delivered] and [Delivery Date: Sum: Releases Delivered On Time]. Each gets set to a value of 1 or 0 depending on the order release status. I'm trying to do a basic on time delivery calculation, but it keeps returning the number of releases delivered instead of the…
When designing or personalizing reports, I use Report Designer. I cannot transform the layout of the data visible in the rows - SELECT ABCDE001.VALUE1, ABCDE001.VALUE2 FROM ABCDE001 VALUE1 VALUE2 10 100 55 550 24 240 On the arrangement of data in columns (pivot) VALUE1 10 55 24 VALUE2 100 550 240 How to make such a…
I am trying to perform either (* or / ) between two records however the output is always 0. However whenever I tried to + or - operations, it works. Lets say: Column 1: Value 20 Column 2: Value 10 I tried this → SavedExpression('Column1')/SavedExpression('Column2') and the output is always 0. What am i doing wrong?
I want to export the dashboard using the top right button that converts it to a printable pdf. This does not work and it shows download failed. What can be the reason for this and how could i fix this?
Quick question. If we have two records going into a script with a source that has 5 columns as the key, but we are only setting up our LK with 4 of the fields. If, within one scripted source run, there is two records as follows, would it insert both as it doesn't know the LK exists in the previous record yet to do an…
Is there a flag field or some other way to identify if the customer is in standard or daylight savings time? I have created a BQL expression for Pacific time using DateAdd which will work until 11/03/2024, when DST ends. DateAdd(Hour,-7,NOW) Ideally I would like to avoid having to edit the expression whenever the time…
I have found an interesting info here: https://dragonden.agiledragongroup.com/c/resources/issue-with-calculated-averages-in-summary It talks about the well-known issues with averages at the Summary level in reports. Specifically, it says: Birst has an account level setting called ‘LegacySummary Flag’. Only Infor can turn…
It looks like you're new here. Sign in or register to get started.