cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

View Entire Topic
Former Member
0 Kudos

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

Also show suppression formula too.

Ian

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Hi,

can u tell how to do formula descending ?

Regards,

Shanthakumar.

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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

Ian