Find Related Values of The Values?

[khasimvali85]

Hi COmmunity,

                    Please provide me formula for design purpose. i wanna display PartNo also as well as Complaint No.

Regards,

Khasim.

[anbu1984]

Can you explain your requirement

[ashfaq_haseeb]

Like this

Regards

ASHFAQ

[khasimvali85]

Hi Anbu,

          Thanks for reply i have attached my requirement application, In this application front end i have designed one Pivot Table, in this table i have columns like ASC_ID is the Dimension and the expressions are ReminderCount, ComplaintNo,ReminderCalls, >3ReminderRed,>3 Calls ComplaintNo and the expressions are in given application.

i wanna add another column like i wanna disply PartNo also .

Regards

Khasim.

[khasimvali85]

Hi Ashfaq,

                    I wanna disply only partno i have partno column available in application.

Example:

9156	0	ComplaintNo	ReminderCalls	>3Reminder Red	>3CallsComplaintNo	PartNo
9155	1	NAG1009140113	1	1
9153	8	BAN1009140003;BAN1209140149;BAN1309140171;BAN1509140020;BAN1509140188;BAN1509140198;BAN1609140003	1,1,1,1,1,1,2	1;1;1;1;1;1;2	BAN1509140020	132424352
9152	2	RAJ1009140121	2	2	RAJ1009140121	7623786376

[anbu1984]

=Concat({<ReminderDate= {'$(=vReminder)'}>} DISTINCT RemComplaintNo & '|' & REMINDER_PARTNO,';')

[ashfaq_haseeb]

Replace Expression with

=max(REMINDER_PARTNO)

Regards

ASHFAQ

[anbu1984]

Which column is PartNo (REMINDER_PARTNO)?

[khasimvali85]

Hi Anbu,

               Not like that i wanna display only complaintno's partNo only.

Regards

Khasim.

[ashfaq_haseeb · Accepted solution]

Try this expression

=Concat(If(AGGR(SUM({<ReminderDate={'$(=vReminder)'}>}ReminderCall),RemComplaintNo)>=2,REMINDER_PARTNO),' : ')

Regards

ASHFAQ