Forum Discussion

DJsummers's avatar
DJsummers
Helper I
4 years ago
Solved

IF Function Assistance

Hi In the below table, I have a Standard weight and I have a parent age. If the parent age is below 35, then I want the standard weight to be reduced by 5% (multiplied by 0.95) I tired doing it...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi DJsummers 

     

    Use SUMX instead of SUM

    New Target = IF('CumulativeWeightsView2'[ParentAge]<35, SUMX('CumulativeWeightsView2', 'CumulativeWeightsView2'[StandardWeight]*0.95))

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
4 years ago

Hi DJsummers 

 

Use SUMX instead of SUM

New Target = IF('CumulativeWeightsView2'[ParentAge]<35, SUMX('CumulativeWeightsView2', 'CumulativeWeightsView2'[StandardWeight]*0.95))

 

Regards

 

Phil