If field A = Field B then give me Field C

[hopkinsc]

Hi all,

I am struggling to get something working in a chart. 

Basically i have data like the following..

So what i am trying to do is get the name associated to the ReadingDate that matches the DueDate, so in this case i would want to return name C.

Can anyone help please? Sample attached

ReadingDate	DueDate	Name
01/01/2018	10/08/2018	A
02/03/2018	10/08/2018	A
10/08/2018	10/08/2018	C
12/08/2018	10/08/2018	B
15/09/2018	10/08/2018	B
05/10/2018	10/08/2018	D

[m_woolf · Accepted solution]

Maybe:

[sunny_talwar · Accepted solution]

Try this

Concat(DISTINCT if(ReadingDate=DueDate,Name), ', ')

[hopkinsc]

Hi Sunny,

I need to make a change to this but i can't seem to get it to work. 

What i need is to compare the ReadingDate to the max DueDate.

I have tried wrapping max() around the DueDate but it doesn't seem to work. 

Any suggestions?

New sample attached. 

[sunny_talwar]

May be this

Concat(DISTINCT Aggr(If(ReadingDate = Max(TOTAL <Customer>  DueDate), Name), Customer, ReadingDate), ', ')

[Masi_Sahargahi]

Hi

How about handling it in scrip(as I did in attached sample)?