User Profile
zeelongtime
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Problem with Grand Total not totalling all the values
Hi there, I need help calculating the grand total correctly on the Allocation Column. The idea is to get the 4 Mo Average to populate everytime the 202001 Allocation Tons is 0, The formula I have in as follow which provide what I want at the cell level but total is wrong. =IF(HASONEVALUE(Data[202001 Allocation Tons]),SUM(Data[4 Months Average]),SUM([202001 Allocation Tons])) ThanksRe: Dealing with Measure Totals
Hi there, Im having problem with the Grand Total for the Allocation Column. The idea is when the 2021 Allocation has no value to give me the average else if tere is value just give me that value. The formula is : =IF(HASONEVALUE(Data[202109 Allocation Tons]),SUM(Data[4 Months Average]),SUM([202109 Allocation Tons])) which provide the correct value at the cell level but the total is ot accurate. Thanks for the help.
