Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

help with expression in GBP (money)

Hi guys I have an expression

I need to get the end value in £GBP

Can someone assist me please

=money(sum({$<[GC]={"Body"}>}Sales))-money(sum({$<[GC]={"Body"}>}Budgets))

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

money(sum({$<[GC]={"Body"}>}Sales)-sum({$<[GC]={"Body"}>}Budgets),'£#,##0.00')

View solution in original post

1 Reply
Highlighted
MVP
MVP

money(sum({$<[GC]={"Body"}>}Sales)-sum({$<[GC]={"Body"}>}Budgets),'£#,##0.00')

View solution in original post