C
CAM
Hello,
I am trying to sum a column that has percentages. For example there is a
column call "Amount" containing a dollar amount and another column call
"Gross Sales" I have a calculated field call "Percentages" the formula is
{Amount/Gross Sales) what I want to do is to sum the "Percentage" field in
the footer not in the detail band. I even try to break out the formula, but
I do not get the correct results that should be "100%". How do I do that?
Any tips or website to visit will be appreciate. Thank you in advance.
I am trying to sum a column that has percentages. For example there is a
column call "Amount" containing a dollar amount and another column call
"Gross Sales" I have a calculated field call "Percentages" the formula is
{Amount/Gross Sales) what I want to do is to sum the "Percentage" field in
the footer not in the detail band. I even try to break out the formula, but
I do not get the correct results that should be "100%". How do I do that?
Any tips or website to visit will be appreciate. Thank you in advance.