Help with expression

[#1]

I have the following expression

=(Sum({<CalendarDate={'>=$(=AddMonths((MonthStart(Today())),-12))<=$(=mONTHEND(AddMonths((Monthend(Today())),-1)))'}>} AccountBalance)*-1)

and it works well with getting the previous 12 months., But I need to divide that expression with basically the same formula, but I only want to see when 'NewFRXTitle={Sales}' the total of that.

I am trying to get percentage of sales, here is my working formula, but it won't do previous 12 months, I am trying to get the formula below to work with the formula above for the previous 12 months.

Sum(AccountBalance)/Sum({<NewFRXTitle={Sales}>}total <[CalendarYear]> AccountBalance)

Please don't send any files as I only have qlikview personal edition.  any help much appreciated

[Gysbert_Wassenaar · Accepted solution]

This?

(Sum({<CalendarDate={'>=$(=AddMonths((MonthStart(Today())),-12))<=$(=monthend(AddMonths((Monthend(Today())),-1)))'}>} AccountBalance)*-1)

/

(Sum({<NewFRXTitle={Sales}, CalendarDate={'>=$(=AddMonths((MonthStart(Today())),-12))<=$(=monthend(AddMonths((Monthend(Today())),-1)))'}>} AccountBalance)*-1)

[#3]

Works perfect,thanks!