Regarding max() function in the list box expression

[skiruthigadevi]

Hi Friends,

I appreciate your time. Below is my scenario, could you kindly let me know your valuable thoughts on the same.

I need to display sales weight in a list box selection only if max(weight indicator) is 1.

my metrics display is from data island.

I have attached the sample document and  metrics display excel where the metrics are  from data island.

Thanks,

Kiruthiga

[sunny_talwar · Accepted solution]

May be this?

=if(Max(TOTAL weight_ind)=0,if(_vWeighted=0,_MetricName),_MetricName)

[skiruthigadevi]

Hello Sunny,

Thanks a lot, much appreciate your time.It worked!!