Forum Discussion

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

Problem with formula

Hello,   I have a problem with my formula and i don't understand why it's not possible to do this.   DIFF = CALCULATE(SUM(Commandes[LCCNVALCDE]);TEST[References.ValeursUtilise])-CALCULATE(SUM(Com...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi AlexGallet01

 

 

Make this as a calculated column first:

 

Some column = IF(TEST[References.ValeursUtilise]<>"H-OF";TEST[References.ValeursUtilise]+1;BLANK())

 

 

Then create your measures after and adjust them to your newly calculated column.

 

Let me know how it goes.

 

Best,

Martin

AlexGallet01's avatar
AlexGallet01
Helper IV
9 years ago

Hi ValubiMartin,

 

I can't do this column i have an error message with value before H-OF.

The message speak about impossible to convert my value type of string in int.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Can you send me a picture of how your data is stored?

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi AlexGallet01,

         

        You can try to use below calculate column formula if it suitbale for your requirement:

        DIFF= IF(TEST[References.ValeursUtilise]<>"H-OF",CALCULATE(SUM(Commandes[LCCNVALCDE]),TEST[THKTNODOS])-CALCULATE(SUM(Commandes[LCCNVALCDE]),TEST[THKTNODOS]+1),blank())

         

        BTW, I think you should use the index column to calculate the diff. Actually, you are try to calculate between number and text. :smileyhappy:

         

        Regards,

        Xiaoxin Sheng