How to use greater than in set analysis using a single variable?

[#1]

Hi All,

I am working on a outstanding report.

User will input different outstading days which will be stored in a variable "vOutStandingDays".

This variable is used to show the outstanding amount in a text object.

=num(Sum({<VehicleSparesType={'Vehicle Sales'},OutStandinfDiff={'>=$(vOutstandingDays'},  BusinessArea={'CA01'}>} Outstanding)/10000000,'###,##,##,###.00')

But it does not give me any output.

Please help for "how to use greater than only in set analysis using one variable'

Thanks in advance.

[tresesco]

Missing a closing parenthesis after variable:

'>=$(vOutstandingDays)'}

[MK_QSL]

=num(Sum(

     {$<

               VehicleSparesType={'Vehicle Sales'},

               OutStandinfDiff={'>=$(vOutstandingDays)'}, 

               BusinessArea={'CA01'}

     >}

     Outstanding)/10000000,'###,##,##,###.00')

[jagan]

Hi,

Try like this

=num(Sum({<VehicleSparesType={'Vehicle Sales'},OutStandinfDiff={'>=$(=vOutstandingDays)'},  BusinessArea={'CA01'}>}Outstanding)/10000000,'###,##,##,###.00')

Regards,

Jagan.

[sunilkumarqv]

Hi Sarang

try like this

=num(Sum({<VehicleSparesType={'Vehicle Sales'},OutStandinfDiff={"<=$(=vOutstandingDays)"},  BusinessArea={'CA01'}>}Outstanding)/10000000,'###,##,##,###.00')