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
Sorry to ask this but how can i attach a qvw to send you?
Check this
Try this
Sum({<Deal = {"=Cap <= Rate + $(vShock)"}>} Balance)
1)I'm actually changing from SUM(IF()) to set modifier to gain performance.
2)vShock is dynamic yes.
3) Cap and Rate are linked and in the same table. Rate is the interest rate on an account. Cap is the maximum interest rate on that same account
4) Although it seems very interesting, I'm not sure I fully understand the naked field concept. Is the following expression (that works) a naked field example: sum({<fiedl1={$(=field2)}>}balance)
Thank you
I don't know why but I can only see the Mention and App features. The Attach is not visible.
Check the attached image and qvw
Thank you Sunny it worked! Can you please explain to me what you had to put Deal?
I can, but I think HIC did a great job of explaining this here
No man like HIC.
Again many thanks!
Bryan
Hi Sunny,
Maybe you can help me with the following. This is a continuation of yesterday's discussion.
I have 3 scenarios. 2 of them worked with the syntax you gave me
Scenario 1: Rate+Shock > Cap
Scenario 2: Rate+Shock < Floor
How do you solve it with 2 conditions
Scenario 3: Floor<Rate+Shock and Rate+Shock<Cap
I tried the below syntaxes:
Sum({<Deal = {"=Floor<(Rate + $(vShock)) Cap>(Rate + $(vShock))"}>} Balance)
Sum({<Deal = {"=Floor < Rate + $(vShock) < Cap"}>} Balance)
Finally,
Sum({<Deal = {"=Floor < Rate + $(vShock)"}, Deal = {"=Cap > Rate + $(vShock)"}>} Balance).
This last one returned a result but not the one i want as i need the set to be evaluated on the same row. A rate has one cap and one floor only
Many Thanks