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
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

      • AlexGallet01's avatar
        AlexGallet01
        Helper IV
        9 years ago

        No mi calcul it's between the sum of price command where my thknodos have the first value and th sum of price command where the value of thknodos  have the second value. And next i want to do this between all thknodos.