Forum Discussion

Arnault_'s avatar
Arnault_
Icon for Resolver III rankResolver III
5 years ago
Solved

MdxScript(Model) / Calulcation error in (...)

Hi All, I have created several mesures to define a confidence interval for my data. The measures seem to work fine when I use the "card" visual. When I try to use a "table" visual, I get that error...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
5 years ago

Hi Arnault_,

 

The confidence interval can not  correspond to a single line.

And then you need modify the data type of mrasure [Selling price - conf. level 95%].

Here is the output:

 

Best Regards,

Link

 

  • Arnault_'s avatar
    Arnault_
    Icon for Resolver III rankResolver III
    5 years ago

    Hi v-xulin-mstf ,

    Well, what type should I use? I don't get it.

    BTW, I figured out that the measure does not work when the standard deviation cannot be calculated.

    Indeed [Selling price - conf. level 95%] depends on [Selling price - Std Dev]. I have tried to handle this error but without succeeding. How can I proceed? The expected output would be: if Std Dev is blank or produces an error, then conf. level = blank.

      • Arnault_'s avatar
        Arnault_
        Icon for Resolver III rankResolver III
        5 years ago

        Ok, that's the problem. I thaught that we could handle this issue. If one of the argument is not matching, why isn't it possible to get an alternative output which in that case could be "blank" as I suggested.

        Something like:

        If [Selling price (Std Dev)] ≤ 0, then blank(), otherwise [Selling price - conf. level 95%].