BAQ calculated field that looks to see if two fields are True


(Thomas Dejager) #1

I would appreciate advice on a formula setup.
I would like to create a new calculated field in a BAQ which looks to see if both the OverridePriceList field and the LockPrice field each show True. If both are true, then I want to see True result, and if they both aren’t flagged as true then return a result of false.
Thank you


(Brandon Anderson) #2

We don’t have any lines with any of these true for me to test, but it doesn’t bomb out, so it should work.

(case when QuoteDtl.OverridePriceList = 'true'  and QuoteDtl.LockPrice = 'true' then 'true' else 'false' end)


(Thomas Dejager) #3

Brandon,
thanks for the help, it worked.
My error was not using ’ ’ in each instance.


(Jose C Gomez) #4

For a boolean (bit) field you should use 1 and 0 in SQL.


(Brandon Anderson) #5

Don’t listen to him, he’s just mad that he didn’t get to the answer first…

But yes, true SQL is 1 and 0. Epicor will take either.


(Jose C Gomez) #6

image

you messing with me stats man