Skip to Content
avatar image
Former Member

Calcs not correct?

XI31 - SP3

I have two metrics (measures) 1 and 2. In deski, I run a quick validation comparing the two on a % basis by "sum(1-2)/2" and I get the correct %, However, when I try to incorporate this as a metric (measure) within designer, I get different results?

I have tried many variations, I think I remember a mention of a possible parameter change to resolve this, but I can't find it?

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 05, 2010 at 04:26 PM

    Hi,

    What is the SQL syntax you wrote in the universe?

    Sum(1-2) / 2 OR (Sum(1) / Sum(2)) / Sum(2) OR somenthing else.

    Didier

    Add comment
    10|10000 characters needed characters exceeded