Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Varience

I have calculated Variance (Actual_Budget) in my pivot table which is attache H/w

I want to the Variance to appear as follows

GROUP_DESCRIPTION

Actual

Budget

varience

SALES

100,000

150,000

(50,000)

COST OF SALES

40,000

70,000

(30,000)

GROSS_PROFIT

60,000

80,000

(20,000)

STAFF_EXPENSES

10,000

15,000

5,000

ADMIN_EXPENSES

2,000

3,000

1,000

SELLI_EXPENSES

4,000

6,000

2,000

FINAN_EXPENSES

1,000

1,500

500

TOTAL_EXPENSES

7,000

10,500

3,500

OTHER INCOME

3,000

4,500

(1,500)

NET_PROFIT

50,000

65,000

(15,000)

Favorable Variance should be green without brackets. But in my Pivot table it is shown within brackets

Pls correct my expression to suit my requirement

0 Replies