
Contributor
2022-06-29
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count If with Multiple Conditions and Division
Greetings,
I'm trying to string together a formula that currently works as follows, however, I want to add another condition for BOTH counts. In another joined table, I have acquisition dates, and I want to only count units in the months after the acquisition date. Is this something anyone might know how to do? Any help would be greatly appreciated.
count(if([Unit Availability] = 'Unavailable',[uni_int_UnitId-unu_int_UnitId]))/Count(total <[LastDayOfMonth-unu_dtm_Datetime.autoCalendar.YearMonth]> ([uni_int_UnitId-unu_int_UnitId]))
354 Views
1 Reply

Creator
2022-06-29
11:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you expand on your problem a bit more and explain what unu_int is?
From your description it sounds like adding set analysis into the expression e.g. {transaction_date > acquisition_date}
336 Views
