Charts - Nnumbers from complex foruma not displaying

[datenis]

Hi,

I have a report where the chart is based on the sum of a number from the group divided by a second number,

for example the formula of formula field A would look like this:

(SUM(YTDSALES,GROUP1)/X)

When I try to generate a bar chart using this number, forumula field A is not displayed on the pick list of available fields.

Then I tried to store the result of the formula into a Shared NumberVar SharedVarA then store this in another formula field B. This time B is displayed on the pick list of available fields but when I preview the chart I get empty results on the chart.

How do I get around this issue?

Thanks in advance.

 

[lbass]

Try creating a formula {@YTDbyx}:

{table.YTDSale}/x

Then use the following formula for your chart:

sum({@YTDbyx},{group1})

Not sure, but I think this might be the equivalent.

-LB

 

[datenis]

Hi lbass,

unfortunately, the suggestion did not work. Any other ideas would be appreciated

Thanks.

 

[lbass]

Please explain in what way it did not work, so that we can learn from it when suggesting other solutions.

-LB