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,

 

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi AlexGallet01,

     

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

    For this requirement, you should create a measure to compare between current and previous. If this is a case, you need to find out a index column to help calculate through all your records.

     

    Regards,

    Xiaoxin Sheng