Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)), '#.##%')