How to know highest number

sreekar_pranav · 10-22-2021 06:08 AM

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

You must be consistent in your request.

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 ?