Text box expression to ignore selections

matthewp — Tue, 13 Oct 2015 10:04:10 GMT

I have a text box with an expression in and i would like it to ignore my selections.

='% Total:' & round(Count(DISTINCT{1} If((Date(MonthName(CREATION_DATE),'MMM-YY')) >= (AddMonths(Today(),-12)),S_ID))

/(100)&'%'

Re: Text box expression to ignore selections

sunny_talwar — Tue, 13 Oct 2015 10:06:47 GMT

May be this:

='% Total:' & round(Count(DISTINCT{1} If((Date(MonthName(Only({1}CREATION_DATE)),'MMM-YY')) >= (AddMonths(Today(),-12)),S_ID))

/(count({1}DISTINCT{$<[STATUS]={'Active'} > } [S_ID]) + count({1}DISTINCT{$<[STATUS]={'Inactive'} > } [S_ID]) )*100)&'%'