I'm guessing that this is a fairly simple issue that I'm not figuring out as a result of my lack of experience in Appsheet. Your help is much appreciated. I've written an expression to find the Percent of Males, Females, etc... (see below) and the expression is working correctly, but the formattiing is just a bit off.
<<(Count(Select(Court[ID],AND([CourtDate]>=Today()-7,[DefendantID].[Sex]="Male")))*1.00)/ (Count(Select(Court[ID],AND([CourtDate]>=Today()-7,[DefendantID].[Sex]="Male")))+Count(Select(Court[DefendantID],AND([CourtDate]>=Today()-7,[DefendantID].[Sex]="Female")))+Count(Select(Court[DefendantID],AND([CourtDate]>=Today()-7,[DefendantID].[Sex]="Intersex")))+Count(Select(Court[DefendantID],AND([CourtDate]>=Today()-7,[DefendantID].[Sex]="Unknown")))*1.00)>>
The result is correct, 64% but displays at 0.64%. Is there a way to edit the expression to account for the decimal point?
Thank you in advance for your assistance!
LinkedIn
Twitter
