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

DJsummers's avatar
DJsummers
Helper I
4 years ago

PhilipTreacy Thanks very much for the response.

 

I have done that (and have learnt about SUMX) but now the new target is enormous, for example, I'd expect to see 0.305 for Day 10. The lowest the new target goes, when changing it to Min is 27353.963

 

Thanks Again
Dan