GetCurrentField query

[knightwriter]

Hi All,

I am using the GetCurrentField(goupname) in the general tab under chart title.

This works fine apart from the group name that it is pulling is made up of an expression (ie =Left([Car sales.first name],1) & .....).

Is there a way I change this expression name to 'Sales Person'? Changing the label name under group setting only works for the cyclic logo and not the chart title name.

Suggestions welcome. Thanks.

[sunny_talwar · Accepted solution]

My bad:

If(GetCurrentField ([activity group]) = '=left ([Sales_Sales.First Name],1) & ' & Chr(39) &'.'& Chr(39) & ' & [Car_Sales.Last Name]', 'Sales Person', GetCurrentField([activity group]))

[knightwriter]

Hi Jonathan,

Thanks for the suggestion but this does not work. I am looking to change the Used Field name so it will appear in the Graph title rather than pull the expression. Your idea only works for the cyclic logo dropdown as far as i can see.

[knightwriter]

Hi Sunny,

Really appreciate the help here but its still is not showing although its says expression is ok!

The only change I have made is that I fixed the table names in the expression from Sales_Sales to my table name.

The error must still rely around the Chr(39) workaround. Any final suggestions?

[knightwriter]

Hi Sunny,

Scrap the above note, it was a spacing difference from '.' to '. ' that did the trick.

Many thanks again and appreciate all the help.

[sunny_talwar]

Awesome

I am glad that finally it worked.

Best,

Sunny