6 Replies Latest reply: Aug 4, 2016 8:05 PM by Yeo Poh sai

# Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

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

• ###### Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

Can i know which expression you are using for Budget variance %

• ###### Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

(

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 %

• ###### Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

Is that, sales_target is Link Table (Key) or direct value?

• ###### Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

It is direct value. As you notice that this field use in table 1 , it display correct %.

• ###### Re: Scatter chart display +100% achieve budget , but correct Budget achieve is -51%

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