Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a year month field ([Calendar Year Month]) , which has been set to 2 months prior to today's date using the following logic and saved as a default bookmark which automatically selects a value in this field upon opening the application:
=if([Date Flag]='Y', [Calendar Year Month])
I also have a chart where I've included the following logic in the title to specify what period the chart is showing:
=if(GetSelectedCount([Calendar Year Month])>0, 'P&L Report: ' & GetFieldSelections([Calendar Year Month]), if(GetSelectedCount([Calendar Year])>0,
'P&L Report: ' & GetFieldSelections([Calendar Year]), 'P&L Report'))
However, when I open the app (and bookmark is automatically applied), the chart title is showing:
Is there a way to make sure the title displays the actual selected month instead of bookmark logic?
Instead of GetFieldSelections, try using Concat.
=if(GetSelectedCount([Calendar Year Month])>0, 'P&L Report: ' & Concat([Calendar Year Month],', '), if(GetSelectedCount([Calendar Year])>0,
'P&L Report: ' & Concat([Calendar Year],', '), 'P&L Report'))
Instead of GetFieldSelections, try using Concat.
=if(GetSelectedCount([Calendar Year Month])>0, 'P&L Report: ' & Concat([Calendar Year Month],', '), if(GetSelectedCount([Calendar Year])>0,
'P&L Report: ' & Concat([Calendar Year],', '), 'P&L Report'))
Perfect thank you!