Jump to content
Sign in to follow this  
Tissot

FM not Finding properly in unstored calc

Recommended Posts

I have a simple unstored calculation (number) field . Its acts as a switch and can either have 1 or 0 in it.

Now when I search for all 0 it show all records. When I serach for 1 it only shows 1's.

The calc is:

If(j.EntryType = "AR" and j.InvoiceType = "1. Installment";

If(j.DeliveryDate>0 or FilterValues(List(SalesInv_JOB::s.InvoiceStep);"2. Installment¶Final invoice")>0 ;1;0);

1)

Now the calc is doing what it should. It show up with the correct result but when searching it has this issue.

Thanks in advance.

Ron

Share this post


Link to post
Share on other sites

Hi Ron,

"It show up with the correct result but when searching it has this issue."

By any chance are you searching a related field? I notice that this calculation involves a SalesInv_Job table as well?

I ask because the results you receive will be matching MAIN records. Let's say a parent record has 3 children with the result to this calculation of:

Record 1 = 0

Record 2 = 1

Record 3 = 1

If you search, you will end up showing this parent record. And it will display 0 in the field you are searching. But that parent DOES have children with a 1 in them; it's just that they can't display. It can be quite confusing. If this isn't the issue, we would need to see your file (zipped empty clone) or a sample file showing the fields and tables involved here. Your calculation is difficult to understand without a file for reference.

LaRetta

Share this post


Link to post
Share on other sites

Thanks. I just put the calculation in the child and now it works fine.

Even so it should of worked becuase the result for the parent was always the same as the child, because its based on data from the parent.

Very confused?!?

Ron

Share this post


Link to post
Share on other sites

Could you post a simple file showing this discrepancy?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.