Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Sum({<Deal = {"=Floor < Rate + $(vShock) and Cap > Rate + $(vShock)"}>} Balance)
I am glad that my post is shared as reference .. Thank you Sunny Bhai
Works like a charm
Thank you Sunny