Forum Discussion
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...
Hi DJsummers
Use SUMX instead of SUM
New Target = IF('CumulativeWeightsView2'[ParentAge]<35, SUMX('CumulativeWeightsView2', 'CumulativeWeightsView2'[StandardWeight]*0.95))Regards
Phil
Hi DJsummers
Try copying the table and then pasting it into Excel.
Save the workbook to OneDrive, Drop box etc where I can download it.
Regards
Phil
PhilipTreacy Morning! (Afternoon?) I'm not being given the copy table option, I am doing a direct query if that makes any difference.
Anyhow, I have copied a sample of both tables via transform data, although the new column you helped me isn't showing.
https://appliedgroupltd-my.sharepoint.com/:x:/g/personal/daniel_summers_optifarm_co_uk/EZp8SWE2S-VCnTU1YgY5A8cBNJjNyHrXHtkVZxqId9jIRw?e=6Fr2MY
