With an excel input, I wanted to validate that the values are numeric, and in the case where the user has a string, error, or blank in the cell I want to cast it as something else. I tried the IsNaN function but it didn't work as I expected. I did IsNaN('test') and it returns false, so that doesn't really help me. Any…
Just created Enhancement Request 116631 as per object: https://mingle-portal.us2.prd3.inforcloudsuite.com/v2/CONCIERGE_PRD/?LogicalId=lid://infor.cxp.1&Tab=ERS&ERId=116631 Please consider endorsing. Thank you! Enrico
Hi, I'm starting to learn Birst so please be understanding :) I'm trying to make relationship between tables MWQIRS and MPDIID through field INSI and it doesn't work. Scripts are just to narrow results to specific CONO and FACI. What possibly am I doing wrong? Thanks in advance for the tips. Marek
Hi, I need to add a new derived field as an additional analyze by date. What is the best approach for data already in the fact table? Do I read the fact table, derive the new field, right out with same grain with the analyze by? There is a very large number of records in the DL, so i do not want to have to truncate and…
Hello, I have a dashboard that has a between date filter. The report has subtotals by date, division, warehouse, stock transaction type. With the subtotal options, am i able to set up a drill across that passes to another report the one date? What if i want to have the item, stock trans, warehouse, division, and date…
I have a columndiagram and I want the segment values to display percentages instead of what it is now. The percentages only show when hovering over the value. Is there a way without changing the measures to achieve this?
Consider the following: Source A LEFT OUTER JOIN Source B ORDER BY FieldFromA, FieldFromB If I do this, it won't effectively do the left outer join as it needs the column from source B. Is there a way to only order by the second criteria if it's not null?
Figure I'd ask before I spin my wheels on this. Normally I'd think to order all of the rows by the global, parent, component to build out some BOM path strings, but LN doesn't have a global - everything is just parent and component. My first thought is I could fake a recursion by joining to a bunch of copies of the same…
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…
It looks like you're new here. Sign in or register to get started.