I’m trying to find measuring component ids that show up at least 3 times. At this time it is throwing the Oracle Error “ORA-00936: missing expression.” I have tried putting in an existing statement to possibly satisfy the missing expression error, to no avail. It either returned too many values or didn’t bring back any values at all. How do
Tag: expression
How to replace a column result if null with another column result in BIRT
I would really appreciate some help with a computed column using an expression in Birt. I have two columns which are giving results, one gives email addresses and one gives contact numbers: telephone, mobile.. When the email result is null then the contact number column shows a number, these are separate communication methods from a table in sql. What I
Why is the output for my datediff expression to return a number of days bracketed?
I have written the following expression to give me the number of days between a date and today. The output is correct but is bracketing the number ie. (292) instead of 292 Any help as to why this is Answer if you are using text box to display your result, check what is the type of your text box. Make
Stop Access from asking for parameters in Query
Access keeps asking for parameters qTtlSalesbyParent!SumOfSales My query SELECT tblCMAP.Parent, Sum(tblCMAP.Sales) AS SumOfSales, IIf(Nz([qTtlSalesbyParent]!SumOfSales],0)>=1000,20, IIf([…