Help PLEASE! How to compare string with Lookup variable?? - linked tables

[aldirjr]

Hi,

I have 2 tables.. basically 1 table is the Procurements, and the other one is the Projects table.

What I am trying to do is to find the amount of Procurements that are related to a Project and update the Project table to add the Total.

the Procurements table, has a Lookup value that has a link with the name of the project... 

I tried to compare the Lookup value from the Procurements table, with the Project name of the Project table and I can't find a way to compare both of them!

Basically, I listed the rows for each table, and then I did an "apply to each" within another "apply to each" (a loop inside another loop) to compare values, and "incremented" the total amount of Procurements in the Project table.

I dont know what I have to put in the conditions... compare what to what...

When I do compare, the Project Name (from Projects) come as "Webpage version 2" and the Projects name from Procurements come as 't1d38e52-0c04-ea11-a722-103d3a794413'

[ManishJain]

Hi @aldirjr ,

What are you trying to accomplish here ?

Thanks

[aldirjr]

Hi.. I thought I was clear haha, my bad..

To summarize.. I want to see if a project has any procurement associated with it (and the total of associations).

Some records in the Procurement table, has a "link" to the Project table (which is a lookup value, not a name - as you can tell by the pictures)...
and I have a table called Projects..

but when I get the Projects name in the Procurement table, I get a code, not the project name or the project id... and I want to compare this, to the Project Name from the Project table, but it is a string! so I cant compare both of them

[ManishJain]

I think you need to have a rollup field created on Project entity and set it as sum of column that you want to aggregate.