Field A = Field B Condition in Sets Does not work

[shyamcharan]

Hi Experts,

I am trying to use the below formula to create Sum of Value based on Fields Equal condition. But it does not work.

Any suggestions please?

Sum({<TimeArrived=TimeUnitAssigned>}Value)

Please find the attached file.

Thanks in advance,

Shyam.

[Clever_Anjos]

It´s not the way Set Analysis works (see here how to write your expressions A Primer on Set Analysis)

If you want to compare two fields you can use this =Sum(If(TimeArrived=TimeUnitAssigned,Value))

[shyamcharan · Accepted solution]

Thanks for your response Clever Anjos.

Thats quite help full link.

I also found the answer in the below link:

set_analysis_intra-record.qvw

Thanks heaps.

Shyam.

[Clever_Anjos]

Nice, so please consider closing the thread marking one answer as "Correct"

Best regards

[shyamcharan]

Done!! Cheers.