variable - set

[priyarane]

Hi Community,

Please give me format for below variable in set

vSearch = <3000 (I am entering in inputbox)

now I have to include above variable in sum(sales)

-Priya

[sunny_talwar · Accepted solution]

May be this

Sum({<FieldName = {'$(=vSearch)'}>}Sales)

[kaushiknsolanki]

Hi,

Do you want to compare the each Sales value against the vSearch and only that value should be considered for expression then try below script.

Sum{<Sales ={">=$(vSearch)"}>}Sales)

Regards,

Kaushik Solanki