Forum Discussion

DJsummers's avatar
DJsummers
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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