Hi,
I am using export button extension to download excel file.I want to download the values based on the selected values in the filter.I am using below query to do that
=If(DimensionType = 'ABC' and AValue='>0.9',ABCValue>0.9,If(DimensionType = 'ABC' and AValue='<0.9',ABCValue<0.9))
DimensionType,AValue are all inline table values and it is given as filter to the users.Now my question is How can I restrict ABCValue(It has probability values from 0 to 1) based on the 'Avalue' .Is there any function that can be used in the place of 'ABCValue>0.9'