above 1000

[sagaraperera]

Dear All

i have a value field in GROSTOT , I want to get a value in sum of above 1000 amount

SALES:

LOAD

BCOD,

         DATE(floor(MARKETING_DATE)) as  MARKETING_DATE,

     GROSSTOT

sagara

[jmvilaplanap]

Hi,

I don't understand exactly what do you want, but I'll try 😜

SALES:

LOAD

     BCOD,

     DATE(floor(MARKETING_DATE))      AS  MARKETING_DATE,

    sum(GROSSTOT)                              AS GROSSTOT

WHERE GROSSTOT >= 1000

GROUP BY BCOD, MARKETING_DATE;

Is this what do you need?

Regards

[tresesco]

May be this (with preceding load)?

SALES:

Load

          *

Where GROSSTOT>1000;

LOAD

          BCOD,

          DATE(floor(MARKETING_DATE)) as  MARKETING_DATE,

          Sum(GROSSTOT) as GROSSTOT

From <> Group By BCOD, MARKETING_DATE;

[Kushal_Chawda]

Or you can use the set analysis in your expression like below

=sum({<ID ={"=sum(GROSSTOT)>1000"}>}GROSSTOT)