Hi expert,
I have tax reg number (customer.vatregnumber) format like 99-9.-9989.000
and have Saved searches formula as shown below:
case when {customer.isperson} = 'T' then '000000000000000' else COALESCE({customer.custentity_ef_vatregnumber},{customer.vatregnumber}) end
i want to display the result for {customer.vatregnumber} without character, what is the formula looks like ?
thanks
agus