Set modifier field greater than field and variable

[Anonymous]

Hello,

I'm trying to compare a field on one part to a field and a variable on another part, inside a set modifier.

Business Rule: Cap<= (Rate + vShock)

The Cap and Rate are fields and the vShock is a variable.

I have tried the following syntaxes:

sum ({<Cap={"<=$(=Rate + $(vShock))"}>} Balance)

sum ({<Cap={"<=($(=Rate) + $(vShock))"}>} Balance)

sum ({<Cap={"<=$(=Rate + vShock)"}>} Balance)

[...]

I know how to use a set modifier for a variable alone, and for a field alone (dollar expansion) but I'm struggling with merging them.

Any thoughts?

Thanks

[sunny_talwar]

Try this

Sum({<Deal = {"=Floor < Rate + $(vShock) and Cap > Rate + $(vShock)"}>} Balance)

[shekhar_analyti]

I am glad that my post is shared as reference .. Thank you Sunny Bhai

[Anonymous]

Works like a charm

Thank you Sunny