Hi Glen.

Just to be clear, are you referring to the Graphical Join Tool in the Sage Intelligence Connector or to a tool in X3 ERP?

I'm referring to the X3 tool (GESALT) at: Setup-->Usage-->Reports-->Graphical query tool

Hey Glenn,

I've never tried doing an expression like that in a requester but I suppose you could give it a shot in a calculated field. It's supported in the formula wizard. When I've needed to do this, I use case statements in SQL queries or views and then create an X3 view or an X3 SQL requester to expose the information I'm trying to get into a gadget. Hope this helps.

Glen -

I suspect the single quotes would lead to an 'illegal character' error - so you could try changing them to double quotes.  ie "BBL" instead of 'BBL'

If this doesn't do it for you then I'd suggest rewriting the statement using boolean logic as follows:

([F:ITM]SSU = "BBL")*([F:ITM]SSUSTUCOE*[F:SID]QTYSTU*[F:SIH]SNS)

As far as I know conditional expressions are not supported in X3 Expression formulas. I know it is very frustrating I’ve tried this many times whether it is in workflows, requestors… it just won’t work.

In your case the boolean idea should work. But let’s say your else statement would be some other value not 0 then it won’t work. Or let’s say you need a conditional statement on a character value it won’t either work. What I found is that for Requestors the best and easiest solution is just to use the SQL requestor and write your own Sql. For other areas you can write a function in some process that would have your conditional expression and then call the function from the expression formula something like func MYPROCESS.MYFUNCTION(param1,param2) .

Thanks everyone.  The Boolean worked for me in this situation, but I also see Israel's point that other conditional statements may not work.  Luckily, we've got options for reporting tools -- each having their unique advantages or limitations.

You can call a FUNC program as a fomular