Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try: Sum({< Rep={'Harry'}>} distinct DailyBudget*Selldays)
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.
Hi Johannes,
thanks for quick reply
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
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
try: Sum({< Rep={'Harry'}>} distinct DailyBudget*Selldays)
Hi Carmen,
thanks for your reply I see your logic with your suggestion tried several different combinations
but no go
Peter
Hi Gysbert,
thankyou champ!
after a bit of testing and fixing my errors it works
thnaks again
regards Peter