Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can I put an expression in the Title of a chart?
I have a chart called "Performing Customers for the Month". I would like it to say "Performing Customers for April", with the month name being determined by the expression.
This is the expression I use to determine the number of performing customers, so I could use the variable to determine the "current" month (which is just the maximum month).
COUNT({1<[Effective Year]={$(=($(vCurrentYearPurchase)))},[Effective Month]={$(=($(vCurrentMonthNamePurchase)))},[Tran Code]*={35}>} [Effective Date])
Thanks,
G
Hi
Use
='Performing customers for ' & Month($(vCurrentMonthPurchase))
Regards
Anders
Hi
In Window title
Put in
=COUNT({1<[Effective Year]={$(=($(vCurrentYearPurchase)))},[Effective Month]={$(=($(vCurrentMonthNamePurchase)))},[Tran Code]*={35}>} [Effective Date])
Regards
Anders
Hi Anders,
I am using =Month($(vCurrentMonthPurchase)) and that works fine, but it just gives me the monththen - April.
I would like the title to be "Performing customers for April", so it must be normal text, and then the expression value.
Possible?
Thanks,
G
Hi
Use
='Performing customers for ' & Month($(vCurrentMonthPurchase))
Regards
Anders