Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
=if(Max(TOTAL weight_ind)=0,if(_vWeighted=0,_MetricName),_MetricName)
May be this?
=if(Max(TOTAL weight_ind)=0,if(_vWeighted=0,_MetricName),_MetricName)
Hello Sunny,
Thanks a lot, much appreciate your time.It worked!!