on 09-07-2015 2:45 PM
Hi,
I have Profit Ctr Dimension and in report i have the below display:
I am trying to display the field values as below:
Services
Proof
910
721
Im struck becuase it has string values and not able to trim only first 3 numbers dynamically
Thanks,
Dinya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use this.
=Substr([Prof Ctr];1;Pos([Prof Ctr];"_")-1)
Amit
Amit,
Services and Proof Not showing.. others are good ..
Dinya
=If(Match([Prof Ctr];"*_*")) Then Substr([Prof Ctr];1;Pos([Prof Ctr];"_")-1) Else [Prof Ctr]
Thanks it worked quick as you reply.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.