Formula Calculation in QV Straight Table

[pradnya_amol]

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,

Pradnya.

johnw‌ !

[Anil_Babu_Samineni · Accepted solution]

Try this way?

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

[shreya_nadkarni]

[shreya_nadkarni]

=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)

[pradnya_amol]

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.

[shreya_nadkarni]

=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)

[tresesco]

Try like below:

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

[pradnya_amol]

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

[pradnya_amol]

It worked when I changed the Column Name / Expression name

[pradnya_amol]

Thanks a ton Shreya.