Logic

[smilingjohn]

Hi ALl,

Please find the attachment of the qvw file .

Here i have bar chart which has the dimesnion  defectsummaryreportperiod  this is statring form NOV ..

The requirement is like it should show the 13 months from the selected date from Orderdate and the date format is MM-DD-YYYY.

say for example now i have selcted 11-11-2017.....that means and if you look at the bar chart it is showing 13 months charts...starting from NOV 2016 to NOV 2017..

but if i select October it will show 12 months... the starting will still be NOv..

Please help me on this ...If i slect in future Dec from Orderdate then the bar chart should start from Dec... so that it will be 13 months ..

How can ia chive this ...

Thanks in advance

[HirisH_V7]

As we are doing accumulation, For  Progress  i.e DSRunningOpenCount , as it consists of negative values in it. Its showing results as per the expression itself.

Else, please let us know whats your desired output. As per the existing data , for third expression.

PFA, & FYR

Hirish

[smilingjohn]

HI Hirish..

Please find the atachment of my qvw ..

Here if you see none of the runing total is going in negative..

as per your suggestion the first two expressiona are working properly..the runing total shows negative..which should  not show the negative values....

Can you please help me with this ..

Please help

thanks a lot

[stabben23 · Accepted solution]

use this Expression and use no accumulation.

RangeSum(Above( Sum(DSRunningOpenCount),0,Rowno()))