-
Beast mode: SUM BY ORG NAME the AMOUNT if the state is granted or closed
Hi: Can anyone help with Beast Mode code: For each organizations_name, I want to get the sum of requests_amount_recommended if requests_state is granted or closed. organizations_name requests_state requests_amount_recommended org A pending_review 10,000.00 org A closed 10,000.00 org A closed 75,000.00 org A closed…
-
SQL for calc fields that sum (data is flattened) are dynamic -- based on current year
Hi there: I need help creating these calculated fields (in Beast Model) where they change based on current year. I created this in EXCEL but am still learning SQL - any help would be much appreciated! calculated fields cy Sum `rtfs_amount` for each DISTINCT `Base Request ID`where `fsa_spending_year` is current year cy+1…
-
Concatenating amount and number fields WHILE also formatting them?
I am trying to create this as output in a cell: $50,000/ 2.0 year(s) This is my code: CONCAT(request_amount_recommended,'/',' ',Duration in Years,' ','year(s)') However, when I concatenate, I'd like for amount to be in US currency format and the number to be with 1 decimal. I get this "50000/2.014646 year(s)" Any help will…
-
Table formatting
I have a table with a header that is made of up 2-3 rows and some of the cells are merged (see sample screenshot). Is this custom header possible to create in DOMO?
-
Help with editing code that uses Filter allow
Hi there: BACKGROUND: I have data is a list of grants with organization name, grant amount, status of grant. I have Beast Mode code: SUM(SUM(requests_amount_recommended) FIXED (BY organizations_id FILTER ALLOW requests_granted)) I think it works - the issue is that it is summing TOO much. Ideally, I want to edit this code…
