Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that I want sorted as follows:
Past Due
Today
Due w/in 5 Days
Due Beyond 5 Days
I have added the following expression in the sort tab in the chart properties:
Match(vAGING_ORDER_BUCKET,'Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days')
This is not working as I want with the chart sorting like this instead (whether I choose Ascending or Descending - makes no difference - not that I expected it too):
Due Beyond 5 Days
Past Due
Due w/in 5 Days
Today
Ideas??
use
Only({1}Match('$(vAGING_ORDER_BUCKET)','Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days'))
or
Only({1}Match(vAGING_ORDER_BUCKET,'Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days'))
This formula should work, if vAGING_ORDER_BUCKET is a fieldname.
HTH Peter
use
Only({1}Match('$(vAGING_ORDER_BUCKET)','Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days'))
or
Only({1}Match(vAGING_ORDER_BUCKET,'Past Due','Today','Due w/in 5 Days','Due Beyond 5 Days'))
Thanks for the quick reply. It is a variable not a field. As I'm new to this, I guess that matters. That being the case, do you have another suggestion? I tried the other suggestion by Manish and I still get the same result.
Thanks for the reply. I'm still getting the same result though. As I said to Peter's reply, I'm using a variable and not a field.
I tried the first suggestion by Manish with the $ (which I didn't do the first time - my bad) and it worked! Thank you so much.