correct Sum

[#1]

Hi all!  I have the following table in QV

when Oklad =

if(Column(1)>0,Sum(If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad)))

The results I want is:

In other words, I want to get the correct Sum. Help me, please.

[#2]

Hi,

You can may be use dimensionality() function and use distinct when calculating for Totals and for the others just use the normal expression.

[Anonymous]

I suspect that the condition Column(1)>0 is the source of the problem.  It may be false for a single row which will be hidden, but the total >0, hence the values of Oklad included in total.  Try to think of a different condition.  Or, maybe this, moving this condition inside sum:

Sum(If(Column(1)>0 and vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad))

[#4]

Michael, Sum(If(Column(1)>0 and vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad)) - wrong.

Get all  0,00 (

[PrashantSangle]

Hi,

Try This,

if(Column(1)>0,If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2),Sum(Oklad)))

Regards

[#6]

Hi, if(Column(1)>0,If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2),Sum(Oklad))) get all -

[PrashantSangle]

Hi,

Then you can use Aggr()

Like

if(Column(1)>0,If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2),Aggr(Sum(Oklad),Work,Stavki))

Regards,

[jonathandienst]

Hi

You could try

if(Column(1)>0,

  Aggr(

  Sum(If(vDate_2 >= DateStart2 and (isNull(DateEnd2) or DateEnd2 > vDate_2), Oklad))

  , DateStart2, DateEnd2, Work, Organization

  , Subdivision1, Subdivision2, Subdivision3, Subdivision4, Subdivision5, Subdivision6

  )

)

The chart dimensions need to be included in the Aggr()

HTH

Jonathan

[#9 · Accepted solution]

Stavki =

=SUM(If(vDate>=DateStart and (isNull(DateEnd) or DateEnd> vDate),Stavki))

The correct answer:

Oklad =

Sum(Aggr(if(SUM(If(vDate>=DateStart and (isNull(DateEnd) or DateEnd> vDate),Stsvki))>0,

Sum(If(vDate_2>=DateStart2 and (isNull(DateEnd2) or DateEnd2> vDate_2), Oklad))),Organization,Subdivision1,Subdivision2,Subdivision3,Subdivision4,Subdivision5,Subdivision6, Work))

all thanks! 😃