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[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!

vjnvinod's avatar
vjnvinod
Icon for Impactful Individual rankImpactful 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

 

Christann's avatar
Christann
Icon for Advocate IV rankAdvocate IV
7 years ago

vjnvinod

I am not sure what you are asking. Are you looking for how to create Conditional Formatting(i.e. text or background changes color based on the value), or are you wondering how to create the whole combination of graphics in your screenshot?

  • vjnvinod's avatar
    vjnvinod
    Icon for Impactful Individual rankImpactful Individual
    7 years ago

    Christann

     

    conditional formatting is something i am aware, if you noticed in the pic, there is some indicators(up & down in triangle shape), how can we build that indicators in the table?

    • Christann's avatar
      Christann
      Icon for Advocate IV rankAdvocate IV
      7 years ago

      Sure!, take a look at this link from Curbal.com, and see if this is what you needed.