Division calculation is not working.

Question

Hi all,

I have a requirement in the following way.

I have year and month as dashboard prompt filters.

My report have the following columns (I have selected year 2016 as my filter getting the following data)

Transportername          Measure column (count)     Total column     measure column/total column.

T1                                        2                                        15                         0.0

T2                                        8                                        15                         0.0

T3                                        5                                         15                         0.0

Measure column (count)

===================

count(Distinct "- Shipment Dimensions"."Shipment GID")

shipment gid is a dimension column and it has duplicates so using distinct. I need distinct count.

Total column

==================

sum(count(Distinct "- Shipment Dimensions"."Shipment GID" by "- Shipment Service Provider Dimensions"."Transportername","- Shipment Period Dimensions"."Year") by "- Shipment Period Dimensions"."Year")

Here i need sum of all 3 transporters (selected 2016 as  year in db prompt).

In the third column i am expecting result: 2nd column/3rd column

for eg: 2/15;8/15;5/15

When i try 2nd column code/3rd column code then its giving 0.0 for all the rows.

How to solve this? Any help most appreciated.

Regards,

Ram.

User_CEU9I · Answer

Hi all,

Thank you so much for the reply and the solution.

I should be very careful while developing. I could not notice about data types, blindly divided and unable to get the result.

I will be more focused on while developing.

Regards,

Ram.

[Deleted User] · Answer

Aka "slide #10 and #15 - pre-agg / post-agg respectively"

50 Shades of Fail KScope16

Robert Angel · Answer

Also beware of physical versus logic based measures, logical aggregate first and results for multiplication and division can come out wrong for this reason also.