Logic help to calculate EPLF value against Min APC.

[lalitkgehlot89]

Hi,

In given data I want to show Month & Year wise Minimum APC in a Text box with same date EPLF value.

In Year 2018 Min APC =4.42 and EPLF Value 92.52%. that should be in text box.

In July 2018 Min APC =4.76 and EPLF Value 98.66%. that should be in text box.

[sunny_talwar]

Try these

1) Year

='APC :- ' & Num(Min({<Month>}Aggr(Avg({<Month>}APC), LINKDATE)), '#.00') & Chr(10) &

'EPLF :- ' & Num(FirstSortedValue({<Month>}Aggr(Avg({<Month>}EPLF), LINKDATE), Aggr(Avg({<Month>}APC), LINKDATE)), '#.##%')

2) Month

='APC :- ' & Num(Min(Aggr(Avg(APC), LINKDATE)), '#.00') & Chr(10) &

'EPLF :- ' & Num(FirstSortedValue(Aggr(Avg(EPLF), LINKDATE), Aggr(Avg(APC), LINKDATE)), '#.##%')