Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have created a measure with the help of set analysis to calculate last year revenue is user selects current year.
I am facing an issue is I have some filter like "Client_ID" and "Client_Type" If user select any values from this filter then that numbers to reflect current this number is not changing with any filter.
({1}{<Received_Date= {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"}> }
SUM(if(match( assignment_current_state,'Assignment') and match(is_rr_inquiry,'No') and match(Identifier,'Base_Table'),[USD Total Fees])))
({1< Client_ID = P(Client_ID), Client_Type = P(Client_Type) >}
{< Received_Date = {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"} >}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))
try this:
({$}{<Received_Date= {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"}> }
SUM(if(match( assignment_current_state,'Assignment') and match(is_rr_inquiry,'No') and match(Identifier,'Base_Table'),[USD Total Fees])))
Thanks @jochem_zw for prompt reply.
Filters are working now but for Fiscal year is not working now
({1< Client_ID = P(Client_ID), Client_Type = P(Client_Type) >}
{< Received_Date = {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"} >}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))
({$<Fiscal_Year=P(Fiscal_Year)>}
{<Received_Date={">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"}>}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))
@Aasir This is working properly but i am getting less numbers then expected. What would be the reason ?
({1< Client_ID = P(Client_ID), Client_Type = P(Client_Type) >}
{< Received_Date = {">=$(=Min(addmonths(addmonths(Received_Date,0,4),-12)))<=$(=Max(addmonths(Received_Date,-12)))"} >}
SUM(
if(
match(assignment_current_state, 'Assignment') and
match(is_rr_inquiry, 'No') and
match(Identifier, 'Base_Table'),
[USD Total Fees]
)
))