Is there a way to find whether a record exists on the database or not using FOX formula? SAP BPS engine is returning a 0 value even if the record with the asked selection doesn't exist in the database. I need to differentiate the 0 value that is returned by the database record from the 0 value that is returned because BPS engine couldn't find any such record.
Say I have a FOX formula as follows:
{COGS,PCOC,PCUR} = {QTY,COC,#} * {STD_PRICE,PCOC,PCUR}.
Even if {QTY,COC,#} doesn't exist in the database, the FOX formula engine returns a 0. I should be able to check something like
if {QTY,COC,#} is not NULL
{COGS,PCOC,PCUR} = {QTY,COC,#} * {STD_PRICE,PCOC,PCUR}.
endif.
Is this possible? [I know that "is null" is not possible with FOX as I have already tried it, but I need something on those lines].