how to remove the 0 that is added to the formula result

[Former Member]

Hi,

I have a formula field. i placed the formula field in the group footer. zero (0) is added to the formula result. if the formula result is 8 then i am getting 0.00 and 8 as data when i select the browse field data of that field . how to remove the zero. i also used supress formula for the field. but it is not working. any idea on this regard.

Regards,

Shanthakumar.

[Former Member · Accepted solution]

You need to show us the formula and what you mean by adding zero.

Also show suppression formula too.

Ian

[Former Member · Accepted solution]

hi,

Formula : GRP1Focus

if ({@Grp1BrandName}={@All Brand Names}) then {@FocusValue NBSH}. when i right click the formula field and select browse data. 0.00 and 8 are displaying.

Suppress formula

GRP1Focus=0

Regards,

Shanthakumar

[Former Member · Accepted solution]

What are the other formulae

How many records does the report return? What happens if you place formual in detail line. Rememeber if you place a formula based on details in report footer it will only return valu of the last record returned.

Ian

[Former Member · Accepted solution]

Hi,

The report returns 6 records. I placed the formula in group footer(group is a dummy group not related to the fields). in the group footer, it is showing as 0.00 and when i see in browse data option, there is 0.00 and 8.00 (8 is the result of the formula) . then how to supress this 0.00 in the footer and place 8 in the first position.

Regards,

Shanthakumar.

[Former Member · Accepted solution]

If the formula is in the group footer sort the data by that formula descending, then the highest value will appear in the footer.

Ian

[Former Member · Accepted solution]

Hi,

can u tell how to do formula descending ?

Regards,

Shanthakumar.

[Former Member · Accepted solution]

Hi,

I think Ian means to change the sort on your Group Footer - right-click, select 'Change Group' and change the sort order on the Common tab.

You may also want to try updating your suppression formula to include isnull option. I've had reports that give a 0.00 value because of a formula but including 'or isnull' sometimes works.

Heather

[Former Member · Accepted solution]

Hi,

the formula i created is not coming in record sort expert option. what to do for displaying in Record sort expert. I also tried 'isnull(field)' . but it is giving the correct result. can you tell . how you resolved 0.00 in your report.

Regards,

Shanthakumar

[Former Member · Accepted solution]

As I asked earlier, we need to know what the other formulae look like too.

Ian