How to know highest number

[sreekar_pranav]

Hi there,

So I have table called chapter in which it has all the select columns with decimals I want to make a slice and in the slice I want to know the Highest number in tha table the number is decimal

Thanks in advance

[1minManager]

Use a MAX(Select(… formula to get this

[sreekar_pranav]

Can you give me a bit more information

[Aurelien]

Let’s say your slice name is mySlice
your column with decimals is myDecimals

So, the dereference expression: mySlice[myDecimals] will gives a list of all the decimals in your slice.
So, the expression you are looking for is:
MAX(mySlice[myDecimals])

For further information (I suggest you read it):

[sreekar_pranav]

But here I am not using slice I am using the virtual columns to get the sum total when I am using MAX(TABLENAME[COLUMN NAME]) i am getting error should return true or false

[Aurelien]

sreekar_pranav:

I want to make a slice and in the slice I want to know the Highest number in tha table the number is decimal

sreekar_pranav:

But here I am not using slice

You must be consistent in your request.

sreekar_pranav:

i am getting error should return true or false

That’s probably because you set the column type as being Yes/No ?
What if you change it to being Decimal instead ?

[sreekar_pranav]

Nope I am getting same error

[Aurelien]

Can you please share screenshots of:

• the table structure, including type
• the formula you use

[sreekar_pranav]

I am using the expression in slice

[Aurelien]

Thanks for sharing.
From what I see, you are not familiar with row filter condition and slices.
I strongly invite you to have a look there:

Can you explain with plain text what you are trying to achieve with this slice ?