6 Replies Latest reply: Oct 22, 2012 6:32 AM by Peter Brunner

# Budget Sales set analysis in line chart help!

Hi all,

I need a fresh set of eyes to cross check my work

I have been trying to figure out where I have gone wrong

1) I have a staright table with expression =DailyBudget*Selldays
"Total Mode" set to sum

and I get correct Data no problem!

2) I wish to do same with set analysis in Line graph chart

Sum({< Rep={'Harry'} >}DailySales)  works!

=({< Rep={'Harry'} >}DailyBudget*Selldays) Does not work , if i use sum incorrect values

I have put together a example

Thanks for any help
regards Peter

• ###### Re: Budget Sales set analysis in line chart help!

Hi Peter,

Your table has multiple records for each DailyBudget and Selldays entry.

For example, If you look at Harry, July and area Building, you have three records with a DailyBudget of 457.69 and selldays =22. This results in the total being 30k something instead of the expected 10k.

• ###### Re: Budget Sales set analysis in line chart help!

Hi Johannes,

and yes you are right for Area Building in Aug, but I am looking at Totals across all Areas

as in see straight table totals , I wish to have same totals across all areas in graph chart.

So for Harry..Total. Sales \$30,315 and  total Budget \$36,981.54  in straight table is correct

I can get Correct Sales \$ 30,315 in chart as example

but can Not get correct Total \$36981.54 for Harrys  Budget

Peter

• ###### Re: Budget Sales set analysis in line chart help!

try: Sum({< Rep={'Harry'}>} distinct DailyBudget*Selldays)

• ###### Re: Budget Sales set analysis in line chart help!

Hi Gysbert,

thankyou  champ!

after a bit of testing and fixing my errors it works

thnaks again

regards Peter

• ###### Re: Budget Sales set analysis in line chart help!

Hi Peter,

In order to get correct Total Budget for Harry I think you can try this expression:

=sum({< Rep={'Harry'} >} DailyBudget*Selldays)/count({< Rep={'Harry'} >} DailyBudget)

Carmen

• ###### Re: Budget Sales set analysis in line chart help!

Hi Carmen,