Not able to sum

[Former Member]

Hi Expert,

  I attach a Photo.i can sum of Total Unit but i can't sum of the Total Case and Remain Unit.

   So,how to sum of  Total Case and Remain Unit.??

Please kindly help me.

Regards,

Nandish Shah

[Former Member · Accepted solution]

Hi I think Your formulas having datatype as String

[Former Member · Accepted solution]

Hi,Vissu

    my formula is not String.formula is Num VarChar

[abhilash_kumar · Accepted solution]

Hi Nandish,

If this is reference to the solution provided here: , then here's what you need to do:

1) Modify the @Cases formula to:

@Cases:

whileprintingrecords;

numbervar t_units := {Total_units};

numbervar cas := int(t_units/24);

numbervar case_total := case_total + cas;

cas;

2) Modify the @Remaining Units formula to:

EvaluateAfter(@Cases);

numbervar t_units := {Total_units};

numbervar cas;

numbervar rem := iif(cas = 0,0,t_units MOD 24);

numbervar rem_total := rem_total + rem;

rem;

3) Create a formula called @Display_Cases and place this on the Report Footer:

whileprintingrecords;

numbervar case_total;

4) Create a formula called @Display_Remaining and place this on the Report Footer:

whileprintingrecords;

numbervar rem_total;

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Thanks for ur help.

Using above formula i got solution.

Thanks.

But one more thing is how to arrange sequence wise item.

for eg.

in above image,

how to arrange item like

Free Rio Google

Rio Google

Free Rio KK

Rio KK..

Thanks & Regards,

Nandish

[abhilash_kumar · Accepted solution]

Hi Nandish,

Please post that as a separate question per SCN's rules.

-Abhilash

[Former Member]

Hi Abhilash

I post in a seprate Thread..

-Nandish