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