Chart Looks at Different Data Set - Table

[MM_Group]

Hi Guys

Really strange this one.

I have a slice "InvoicedThisMonth" which is based on the table "qryInvoicedMinusCredits".

I'm creating a chart UX and changing the display name to: "Sales Total: " & SUM([TotalInvoiced])

The Expression Assistant cannot find the column [TotalInvoiced]. So if I look in the 'Columns' assistant the columns available in there are from a totally different table and not from the Slice.

I've double checked the UX 'For This Data' and everything is correct selected.

Expression Assistant Below, these Columns are not from the 'InvoicedThisMonth' slice ??

[Marc_Dillon]

.

[MM_Group]

Ok I got it, I don't need the espression assistant, just add the text:

"Sales Total: " & SUM(InvoicedThisMonthLessCredits[TotalInvoiced])

Into the Display Name field. So can the above be formatted to be Currency?

[Marc_Dillon]

formatted to be Currency

---

Not really, but you can manually do it.

"$" & (ROUND(SUM(...)*100)/100.0)

https://www.googlecloudcommunity.com/gc/Tips-Tricks/How-to-ROUND-to-whatever-interval-you-want/m-p/4...

[MM_Group · Accepted solution]

Thanks @Marc_Dillon very interesting.

But I'm not sure how I would apply that to this: (IGNORE ME)

"Sales Total: " & SUM(InvoicedThisMonthLessCredits[TotalInvoiced])

"Sales Total £: " & (ROUND(SUM(InvoicedThisMonthLessCredits[TotalInvoiced])*100)/100.0)

Many Thanks