Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)&'%'
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)&'%'