Dimension is displaying duplicate values

Prabhu — Mon, 14 Nov 2016 11:54:12 GMT

Hi All,

Below is my load script:

APInvoicePriceVariancebySupplierVendor:

load

C1 AS QtyInvoiced

,C2 AS InvoicePrice

,C3 AS BasePrice

,C4 AS LineNumcount

,C5 AS Currency

,C6 AS EntryType

,C7 AS InvoiceDate

,Date(C7, 'YYYY') AS Year

,C8 AS InvoiceNum

,C9 AS ItemDescription

,C10 AS LineNum

,C11 AS Location

,C12 AS PoNumberRelease

,C13 AS Unit

,C14 AS Vendor,

Date(C7, 'MMM-YYYY') as Invoice_Date,

C15 as InvoicePeriod;

In the straight table, i have taken one dimension "Year" and expression is Sum(InvoicePrice).

The table is displaying duplicate Year values.

I want to aggregate the Invoice Price by Year value. I do not want to see duplicate Year values.

Please do the needful.

Re: Dimension is displaying duplicate values

swuehl — Mon, 14 Nov 2016 11:57:54 GMT

Don't format your date values as years, create year values:

,Date(C7, 'YYYY') AS Year

Instead, use

Year(C7) as Year

Prabhu — Tue, 15 Nov 2016 06:35:00 GMT

Thank You Stefan, it is working fine with your solution