Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
7 years ago
Solved

Measure help

Dear Community,   i have created a margin, which is throwing error, can you let me know what could be the right way to do it?   Margin% = IF(SUM(Inbound[NER_FYTD_Constant]=0,0,SUM(Inbound[MarginF...
Need Help
Show and Tell
  • Christann's avatar
    Christann
    7 years ago

    You have put all of your parentheses at the end! Try:

    Margin% = IF(SUM(Inbound[NER_FYTD_Constant])=0,0,SUM(Inbound[MarginFYTD_Constant])/SUM(Inbound[NER_FYTD_Constant]))

    Hope this helps!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi vjnvinod,

You forgot to close some parenthesis.

 

IF(SUM(Inbound[NER_FYTD_Constant])=0,0 , SUM(Inbound[MarginFYTD_Constant])/SUM(Inbound[NER_FYTD_Constant]))

 

Tell us if it works for you.

 

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    7 years ago

    AnonymousChristann

     

    Actually the output is not showing in % and should be one place decimal

    is there anything we need to tweek in this measure?

    • Christann's avatar
      Christann
      Advocate IV
      7 years ago

      The formatting is not included in the actual Measure. You can simply select the measure in your Fields pane, and then modify the formatting on the Modeling tab > Formatting.

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        7 years ago

        Christann

         

        Great, this helps & an easy one.

        Can you also help me on more issue, i have a metrics, where i want to show the upward and downward trend, something like shown in below (which is basically an indicator )

         

        Not sure, how do i achieve this, as i don't find any option to do that