Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using the dual function with class function for sorting but it is not sorting.
It is giving the same order. I have used the formula (=dual(replace(class([order total],1000),'<= x <','-'),class([order total],1000)).)
Please find the attached file.
Thanks and Regards,
Gayathri Devi
Are you looking for this? If yes, then follow highlighted.
Thank you for the support.
I am trying to know the dual function behavior. Dual function is used for sorting purposes.
But in my case it is not sorting. Can you please provide the solution for the above query.
No body won't say Dual is used only for Sorting. It can capture string + data points together over mouse. Can you check the same. For your case just do Sort by Expression using "order total"
Hi
See this for Dual function
Sorting with class function
The class function returns values with both a text format and a numeric value. So the results of the class function can be sorted by Numeric Value.
For More