Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi There,
can someone tell my why my First Sorted Value function isn't working?
Please find attached .qvf
Regards
Chris
Check the screenshot out:
1) You need to change the formatting to 'Custom'.
2) Your Word1, Value1 has two Min(Value1), I don't know which one you wanted to see, but using DISTINCT would show you one of them.
HTH
Best,
Sunny
Check the screenshot out:
1) You need to change the formatting to 'Custom'.
2) Your Word1, Value1 has two Min(Value1), I don't know which one you wanted to see, but using DISTINCT would show you one of them.
HTH
Best,
Sunny
Yes i know that i had 2 values for that, i was just testing the functionality of it. so i took word2 and value2 without duplicates and had the same problem. That is why i was wondering what the problem could be. So the formatting was the problem!
Thank you
Regards
Chris
Yup