Addition of fields in script

[Rajesh]

Hi All,

I have create two calculate columns in script 1.Approved days, 2. Rejected days

based on this trying to get Total Days of Both using

Approved days+Rejected days as Total_Days But not getting expected values.

Out of that based on using Total_Days trying to display in Textbox object 

1.if Total_Days <=5 than Count (number)

2. if Total_Days >=5 than Count(number).

Can any one suggest the solution.

Thanks

Rajesh

[YoussefBelloum]

Hi,

would you be able to add more details? like sample data or sample app

[Chanty4u]

what is the column values of approved days and rejected days?

[Rajesh]

Numeric values and NULLs

[Chanty4u]

may be

Totals:

load

     Field1,

     sum(Approved) +sum(rejected)  as Total

resident Data

group by Filed1,Field2;

if(total<=5,count(total),count(total)