I'm having trouble understanding what I am doing wrong. I am importing data into a PO solution and some of the data from the import set is incorrect.
It's such a problem that I need to see only PO's whose calculated totals don't match the imported totals.
I have the following fields in my PO database:
PONumber (calculation, result is number)
POTotal (calculation, result is number)
(and other fields that aren't important to the question.)
I have created a table occurrence of PO called PO 2 and created a relationship between the two as follows:
|POTotal||!= (not equal)||ImportedTotal|
What I was expecting when I created a Table View based on PO 2 was a list of only PO's where the calculations did not match. Instead I got a list of every single PO.
Looking at my data I see I have alot of fields that do not match. For instance, I have a PO that has a calculated total (POTotal) of 5635.19, but the value that was imported from our data (ImportedTotal) was 5334.35. I only want those to show up and none of the PO's that match. Even when I created a layout based on my PO table and insert a portal based on PO 2, It still shows every single PO.
Can anyone tell me what I am missing here?