Sections

pgalvezt — Fri, 13 Jul 2012 18:21:08 GMT

Hello, I have an expression with

=sum(num(date(vDate) - (Table1))) this gave me as results = Different days like 897,875,521,21,65, etc

What I want are sections according to the range for example:

section 1 800 - 900;

section 2 10 - 30;

Section 3 400 - 600;

So in the new column should be appears

Section 1 897

Section 1 875

Section 3521

Etc

rangesum(

if(sum(num(date(vDate) - (Table1))) > '800' < 900,'AA'),

if(sum(num(date(vDate) - (Table1))) > '10' < '30', 'BB'),

if(sum(num(date(vDate) - (Table1))) > '400' < '600', 'CC')) etc

I tried as dimenssion too but doesn't work.

Re: Sections

Fri, 13 Jul 2012 18:30:03 GMT

Assuming the dimension for the expression mentioned above is dim1 then the "Section " column expression should be

if(aggr(sum(date(vDate)-Table1),dim1)<=30, 'Section 1',

if(aggr(sum(date(vDate)-Table1),dim1)<=600, 'Section 2',

if(aggr(sum(date(vDate)-Table1),dim1)<=900, 'Section 3','Section 4'

)))

Kiran.