Forum Discussion

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
6 years ago

Hello cristianml 

 

I gave the averagex-formula a test and it seems to work nicely


If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

cristianml's avatar
cristianml
Icon for Post Prodigy rankPost Prodigy
6 years ago

Hi Jimmy801 ,

 

I tried to add "RELATED"  but  I couldn't. 

The table from where comes the Measure Actual LCR  comes from a table that is not a Column, is a category. LCR means Cost rate (marked in yellow in the table) : See the screenshot:

 

So how can I modify the RELATED in this case so can work properly ?

Thanks.

  • Jimmy801's avatar
    Jimmy801
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hello cristianml 

     

    sorry, but I can't follow anymore. I don't know the relationship nor do I understand your datamodel. As shown in my examples the measure I proposed is working (to check another column if it's empty or not equal 0. Now you tell me that is category next.

    I'm very sorry, but I'm not able to help anymore

     

    Jimmy