Problem in Aggr

[raghvendrasingh]

Hi All,

I am making the new column with the help of previous one,But problem is that When i aggregating with new dimension then it giving the zero.Please look into the qvw application (attached below),The column name is final;it should give the value 900 on the basis of Level0.

Requirement is only use column "Value per level1" not "Value".

Please help us .

Thanks,

Raghvendra

[Gysbert_Wassenaar]

Are you looking for sum(total <Level0> Value) ?

[robert_mika]

Try:

if(Dimensionality()=2

, sum(aggr(NODISTINCT sum(Value),Level0,Level1)))

[tresesco]

Use expression:  =Sum(TOTAL<Level0>Value)

[raghvendrasingh]

Hi Gysbert,

Thanks for reply,But I am not looking for this.

I want the same answer with using "Value per level1" Column(i.e. formula column) not Value column.

Because there is a  need to implement this scenario in live application.

Thanks,

Raghvendra

[raghvendrasingh]

Hi,

I want the answer  using "Value per level1" Column(i.e. formula column) not Value column.

Because there is a  need to implement this scenario in live application.

Thanks,

Raghvendra

[tresesco]

Where is your  "Value per level1" column in the sample app?

[raghvendrasingh]

Hi,

Please find the QVW as attachment again.

Thanks,

Raghvendra

[tresesco]

Your calculated column Value per level1 could be got using: =Sum(Total<Level0,Level1>Value), which is more effective in terms of performance.  Now I don't understand why you need this calculated column to use the way you are trying. To say, you can't use a calculated column with Aggr() or Total. May be we could find an alternative have you had explained your real scenario.

[raghvendrasingh]

Hi Tresesco,

Thanks for suggestion.Now I have moved all formulas to backend.

Now Its Working Fine.

Thanks,

Raghvendra