Forum Discussion

colintemlett's avatar
colintemlett
Regular Visitor
3 years ago
Solved

Table Total

Hi   Is it possible to do a specific callcualtion for a row/colum total Per below i need the total NBCP value to being the Total RFS/Total NWB = 435 and not the sum of that column??   Help will ...
  • PabloDeheza's avatar
    PabloDeheza
    3 years ago

    Hey!

    That would be something like this:

    CALCULATE(
	SUM( YourColumnToSum),
	ColumnwithText = "YourWord"
)

    Let me know if that helps!

colintemlett's avatar
colintemlett
Regular Visitor
3 years ago

Hi Pablo

 

Need some help on a formula...

 

What formula would i use if i wanted to total a column value if it includes a specific word in anothe column?

 

If there is a word in column X c that is CONT sum the total colum for only those rows that have that word in the colum X?

  • PabloDeheza's avatar
    PabloDeheza
    Solution Sage
    3 years ago

    Hey!

    That would be something like this:

    CALCULATE(
	SUM( YourColumnToSum),
	ColumnwithText = "YourWord"
)

    Let me know if that helps!