Forum Discussion

MMSS's avatar
MMSS
New Member
2 years ago
Solved

different formats in tabular editor

Hi Guys. I have the following code: I want the measure [a] to have the format= "+#,0;-#,0" und the other measures ([b], [c], [d], [e]) to have the format "+#.0 %;-#.0 %". how am i doing this? ...
  • xifeng_L's avatar
    xifeng_L
    2 years ago

    Hi MMSS ,

     

    You can use below format expression.

     

    SWITCH (
    TRUE (),
    ISSELECTEDMEASURE ([a]),"+#,0;-#,0",
    ISSELECTEDMEASURE ([b],[c],[d],[e]),"+#.0 %;-#.0 %",
    SELECTEDMEASUREFORMATSTRING ()
)

     

     

    Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

     

    Thank you~

xifeng_L's avatar
xifeng_L
Icon for Super User rankSuper User
2 years ago

Hi MMSS ,

 

You can use below format expression.

 

SWITCH (
    TRUE (),
    ISSELECTEDMEASURE ([a]),"+#,0;-#,0",
    ISSELECTEDMEASURE ([b],[c],[d],[e]),"+#.0 %;-#.0 %",
    SELECTEDMEASUREFORMATSTRING ()
)

 

 

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

 

Thank you~