Comments in calculated measures or how can I remember why I did that?

This topic contains 0 replies, has 1 voice, and was last updated by  Frank 3 years, 4 months ago.

  • Author
    Posts
  • #409
     Frank 
    Keymaster
    • Topics Started - 64
    • Replies Written - 52

    Trying to remember why you set up a calculation a certain way or what a specific Iif statement was for can be a daunting task sometimes! A feature that’s been a part of Stratum for a long time but one that we don’t see a lot of users taking advantage of is the ability add comments to your calculated measures. You can easily do this in the Expression window that is used to define your calculated measure. In that window you can start a line with // and then follow that up with a comment – each line of the comment will need to start with //.

    You can see in the example below we added a comment so we could clarify what the iif statment was doing:
    _____________________________________________________________________________________________
    //If we’ve already achieved Plan – set the Run Rate to null

    Iif([Measures].[Data7 (Amt Diff)]<=0,null, #DivideWithZeroCheck([Measures].[Data7 (Amt Diff)], [Measures].[Data17 (Remaining Work Days this month)])) _______________________________________________________________________________________________ Also - remember that you can use the Pop Expression property of a Measure to add comments so that a User can better understand how a calculated number was derived, what the Conditional Format conditions are, or any other info about a measure a user might need.

You must be logged in to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

©2020 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials

or    

Forgot your details?