New Qlikview

[Anonymous]

Actual vs Budget formula.

[avinashelite]

check this

compare actual vs budget

[vinieme12]

How to get answers to your post?

[prma7799]

Hi Aniket,

The variance column is the absolute value (no negative numbers) of the difference between the budget figure and the actual figure. ... Because this is an expense,actual less than budget is favorable. The percent variance is calculated by dividing the variance by the budgeted amount.

[Anonymous]

Thanks guys,

But share the formula for actual vs target in gauge chart.

[prma7799]

PFA ...

[avinashelite]

What you want to show in the Gauge ? actual -target? in Gauge we can have one values at a time .

Share the sample data and required output

[Anonymous]

share the file.

[Anonymous]

also check,