Hi,
I need some help with my formula - separately they are fine, but it doesn't quite work when I combine them together. In the consol I had initially just combined the formulas in A, B & C but it did not work so I then changed the formula slightly (see below). What should the consol formula be?
Thanks
A | IF Line item A = X THEN 'Item A % of Total' * 'Total Amount' ELSE 0 |
B | IF Line item B = X THEN 'Item B % of Total' * 'Total Amount' ELSE 0 |
C | IF Line item C = X THEN 'Item C % of Total' * 'Total Amount' ELSE 0 |
A + B + C [THIS WORKS] | A' + 'B' + 'C' |
Consol. | IF Line item A = X THEN 'Item A % of Total' * 'Total Amount' + IF Line item B = X THEN 'Item B % of Total' * 'Total Amount' + IF Line item C = X THEN 'Item C % of Total' * 'Total Amount' ELSE 0 ELSE 0 ELSE 0 |