How to Sum YTD Revenue using addmonths

[Daniel99]

Hi All,

if i want to sum the revenue for YTD. should i put 'sum' before if on my syntax.

example:

=sum(if([CPR_TM1_202202.Business]='CMB', [CPR_TM1_202202.MONTH]>=AddMonths(today(),-8,[CPR_TM1_202202.amount]))/1000000000

i want sum using kpi chart.

any solution? Thank you.

Regards, 

Daniel

[Daniel99]

still got an error with this syntax

=Sum(if({<[CPR_TM1_202202.MONTH] = {">=$(=2021(Max([CPR_TM1_202202.MONTH])))<=$(=AddMonths(2022(Max([CPR_TM1_202202.MONTH])),-1))"}>} and [CPR_TM1_202202.Business]='CMB',[CPR_TM1_202202.amount]/1000000000)))