Forum Discussion

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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[MarginFYTD_Constant]/SUM(Inbound[NER_FYTD_Constant]))))

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!

8 Replies

  • Christann's avatar
    Christann
    Icon for Advocate IV rankAdvocate IV
    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
      Icon for Impactful Individual rankImpactful 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
        Icon for Advocate IV rankAdvocate 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.