Create a range to filter out empty real value types

(0) Share

Report

Posted on by Community Member

What would be the value on a range of a query if I want to filter out the the values that are empty. The data type is a real. So I would want it to basically be like this:

Table: SalesLine

Field: RemainInventPhysical

Value: !0.00 ---- or ------ !NULL

Like I said the field (RemainInventPhysical) is of Real data type. But the table either has a value with in it or the field is empty and doesn't contain a 0.00.

Any help would be greatly appreciated!

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

640579632b5c4e6780a... 4,730 on at

Like (0)

Report

queryBuildRange.value(strFmt('(RemainInventPhysical != "%1")', queryValue("0")))

queryBuildRange.value(strFmt('(ItemType == %1)', any2int(ItemType::Service)));

Was this reply helpful? Yes No