
Re: Formula Calculation in QV Straight Table
Anil Samineni Oct 10, 2018 7:23 AM (in response to Pradnya Pampatwar)Try this way?
If(Sum(Actuals)>0, Sum(Actuals),Above(TOTAL Sum(Actuals))/Above(TOTAL CalendarMonthNumber)*CalendarMonthNumber)

Re: Formula Calculation in QV Straight Table
Pradnya Pampatwar Oct 11, 2018 12:31 AM (in response to Anil Samineni )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.

Re: Formula Calculation in QV Straight Table
Tresesco B Oct 11, 2018 2:45 AM (in response to Pradnya Pampatwar)Try like below:
If(Actuals>0,Actuals, (Peek(NewRunRate)/(CalendarMonthNumber1)*CalendarMonthNumber) ) as NewRunRate


Re: Formula Calculation in QV Straight Table
Pradnya Pampatwar Oct 11, 2018 6:39 AM (in response to Anil Samineni )It worked when I changed the Column Name / Expression name


Re: Formula Calculation in QV Straight Table
shreya nadkarni Oct 10, 2018 10:11 PM (in response to Pradnya Pampatwar)
Re: Formula Calculation in QV Straight Table
shreya nadkarni Oct 10, 2018 10:12 PM (in response to 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)


Re: Formula Calculation in QV Straight Table
shreya nadkarni Oct 11, 2018 2:05 AM (in response to Pradnya Pampatwar)=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)

Re: Formula Calculation in QV Straight Table
Pradnya Pampatwar Oct 12, 2018 12:34 AM (in response to shreya nadkarni )Thanks a ton Shreya.


Re: Formula Calculation in QV Straight Table
Pradnya Pampatwar Oct 11, 2018 6:38 AM (in response to Pradnya Pampatwar)Yes Dear Thanks. I actually did the same but couldn't post and it worked.