Sum expression

[ZBN22]

Hi,

Im trying to create a slide that sums my sales column to get total sale but i keep getting this message below. 

This is my formula: SUM(Main[Sales]). 

The expression is valid but its result type 'Number' is not one of the expected types: Yes/No

What am i doing wrong here?

[JPAlpano]

This means that the column where you are trying to use this formula in is a Yes/No column, but the result of your formula is a number and is neither a "Y" nor a "N".  Try changing the column type to Number.

[SkrOYC]

Make sure you get what a slice is before Slices: The Essentials - AppSheet Help

It seems like you are using the SUM() expression inside of the "Row filter condition", which is an expression that evaluates on each row of the table to decide if it's going to be added to the slice or not

[ZBN22]

Thanks SkrOYC. Do I then need to create a new table or column to see the total sales? What's your recommendation?

[SkrOYC · Accepted solution]

Usually people add a virtual column with the expression they want to get a SUM() of children records, but we don't know exactly what your current setup is or why you would need that SUM()

[JPAlpano]

Oh! You meant slice? 😄

I thought you are trying to create a view since you mentioned "Slide".

Silly me.

[ZBN22]

Hey JPAlpano

No worries! Thanks for responding though!