Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Chart 1 I want to plot this. it is a scatter chart Y axis Budget variance % X axis is the sales YTD.
Table 1 i have Budget Bariance. at 3th column and YTD sales at 2nd column.
I create Chart 2 , all expression are already correct , only Y Axis to Budget % display wrong.
Table 2 show only 2 group achieve target , but the chart 2 display group 1 achieve budget 100%. But from the Table 1 it shown -51% out of budget.
Hope some one can advise me.
Paul
my qvw
Can i know which expression you are using for Budget variance %
(
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales)
/
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales_target)
)
-1
above is the expression i use for Budget variance %
Is that, sales_target is Link Table (Key) or direct value?
It is direct value. As you notice that this field use in table 1 , it display correct %.
Hi Anil
The Budger vari % expression work fine in table , does not work in scatter chart , can it due what ? Or the expression need to add condition ?
I also notice the error is instead of + ve % it return -ve % , can it cause by the expression is not correct ?
May be some one like to share with me.
Paul
Sent from my iPhone