# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for
Did you mean:
Highlighted Partner

## Accumulate value from the beginning of year to the current month in calculation

Hi,

I want to calculate

Calc1 = Billed Revenue in Jun (current) till  Jan / Total Billed Revenue

I do to like this, but it only show the Jun only not from the beginning of year

Sum({[SPM Year]={'\$(vMaxYear)'},[SPM Est Close Month] = {'\$(vMaxMonth2)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'\$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

1 Solution

Accepted Solutions
Highlighted Partner

## Re: Accumulate value from the beginning of year to the current month in calculation

Thank you for the formula.

But I have to change the month to be in Num to use the <=.

Sum({[SPM Year]={'\$(vMaxYear)'},[SPM Num Month]= {'<=\$(vMonthNum)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'\$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

2 Replies
Highlighted Partner

## Re: Accumulate value from the beginning of year to the current month in calculation

Try this:

Sum({[SPM Year]={'\$(vMaxYear)'},[SPM Est Close Month] = {"<=\$(vMaxMonth2)"}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'\$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))

Highlighted Partner

## Re: Accumulate value from the beginning of year to the current month in calculation

Thank you for the formula.

But I have to change the month to be in Num to use the <=.

Sum({[SPM Year]={'\$(vMaxYear)'},[SPM Num Month]= {'<=\$(vMonthNum)'}>}[Est. Billed Revenue For Current Year]))/(sum({<[SPM Year]={'\$(vMaxYear)'}>}[Est. Billed Revenue For Current Year]))