Skip to Content
0
Jun 05, 2020 at 05:52 PM

[SAP Analytics cloud - creating calculations] Aggregate value without duplicates

151 Views

Hi all,
I recently started using SAC for my data-analyses/vizzes.

Currently having problems with my aggregations since i have multiple records per ID.

Example dataset:

Work-ID Profit FTE City A 2000 1 Toronto A 3000 1 Toronto B 2000 0.8 Boston B 4000 0.8 Boston C 1000 1 New york

I need to calculate:

Total profit and total profit per ID,

A = 5000

B = 6000

C = 1000

Total = 12000

Which works fine.

However i also need to calculate:

FTE per city and FTE total:

Toronto = 1

Boston = 0.8

New york = 1

Total = 2.08

But instead i get:

Toronto = 2

Boston = 1.6

Newyork = 1

Total = 4.6

Is it possible to create a calculation specific for FTE where they return FTE value only for unique ID's?

Thanks.