Forum Discussion

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
1 year ago

Calculation group expression strings vs Measure dynamic strings

Hello   I am attempting to implement dymanic format strings into calculation groups.    For starters - I have a select few measures utilizing dynamic format strings - which are working great.   How...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

I had a similar issue recently, it could be that the 0s and .s need to be escaped. Try

VAR BaseFormat =
    COALESCE ( SELECTEDMEASUREFORMATSTRING (), "#,#.00" )
VAR Label = " " & [ItemPurUnit]
VAR FormatString =
    SUBSTITUTE ( SUBSTITUTE ( BaseFormat & label, "0", "\0" ), ".", "\." )
RETURN
    FormatString
  • Dellis81's avatar
    Dellis81
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    Thank you for your response!

     

    I tried your suggestion, but getting something a little different.   Rounding up, but the additional characters reflect the initial measure value.    I'm not sure what you mean characters need to be escaped?

     

    thank you!