# New to QlikView

Discussion board where members can get started with QlikView.

New Contributor II

## Formula Calculation in QV Straight Table

Hello All,

Need help.

Attached here with is the mini data set of the file I'm working on (Sample Application). I have Month Number, Month Name, Actual Expenses column against which I need to calculate Run Rate in Front End on Straight Table but somehow I am not able to so I tried in Script and failed here as well.

Please take a look into it and help me solving it.

I will be grateful.

Thanks and Regards,

johnw‌ !

Tags (5)
1 Solution

Accepted Solutions
MVP

## Re: Formula Calculation in QV Straight Table

Try this way?

If(Sum(Actuals)>0, Sum(Actuals),Above(TOTAL Sum(Actuals))/Above(TOTAL CalendarMonthNumber)*CalendarMonthNumber)

9 Replies
MVP

## Re: Formula Calculation in QV Straight Table

Try this way?

If(Sum(Actuals)>0, Sum(Actuals),Above(TOTAL Sum(Actuals))/Above(TOTAL CalendarMonthNumber)*CalendarMonthNumber)

New Contributor III

## Re: Formula Calculation in QV Straight Table

New Contributor III

## Re: Formula Calculation in QV Straight Table

=if(Sum(Actuals)<=0,

above( total sum( Actuals ), 1 ) / above(total rowno,1) * max(rowno) ,

Sum(Actuals)

)

for 2nd :Column(2) instead of Sum(Actuals)

New Contributor II

## Re: Formula Calculation in QV Straight Table

Thanks Anil. The problem still persists as it taking only for Sept month and not for the other coming months. Can you please extend your help.

New Contributor III

## Re: Formula Calculation in QV Straight Table

=if(Sum(Actuals)<=0,

above( total sum( Actuals ), 1 ) / above(total rowno,1) * max(rowno) ,

Sum(Actuals)

)

for 2nd :Column(2) instead of Sum(Actuals)

MVP

## Re: Formula Calculation in QV Straight Table

Try like below:

If(Actuals>0,Actuals, (Peek(NewRunRate)/(CalendarMonthNumber-1)*CalendarMonthNumber) ) as NewRunRate

New Contributor II

## Re: Formula Calculation in QV Straight Table

Yes Dear Thanks. I actually did the same but couldn't post and it worked.

New Contributor II

## Re: Formula Calculation in QV Straight Table

It worked when I changed the Column Name / Expression name

New Contributor II

## Re: Formula Calculation in QV Straight Table

Thanks a ton Shreya.