Skipping Last 3 digits on dashboard.

[#1]

Hi,

I need help !!

I've to Skip only last 3 digits[-00] values on dashboard. Please see my attachment.

[ashfaq_haseeb · Accepted solution]

Hi,

Try

subfield(YourField,'-',1) as NewField

Ex:

=subfield(10214488-00,'-',1)

will return 10214488

Regards

ASHFAQ

[kristoferahlin]

left([Sales Order #], 😎 will give you the first 8 digits of that field