cancel
Showing results for
Did you mean:
Contributor II

## Set Analysis Greater than less than a Variable

Hi, I'm trying to use  the following but am not getting a result: I've seen many posts on variables, greater than and equal to and have seen a few different iterations: this is what I ended up with and it is not working.

Any ideas on what part of the expression is incorrect

=SUM({< EFF_DATE ={"<=\$(=vMaxTransactionDate)"} , EFF_DATE = {">=\$(=vMinTransactionDate)"} ,
[TXN_AMOUNT] = {">=\$(=vTXNSum)"} >} TXN_AMOUNT)

1 Solution

Accepted Solutions
MVP

May be try like this:

=Sum({<EFF_DATE ={"<=\$(=vMaxTransactionDate)>=\$(=vMinTransactionDate)"}, [TXN_AMOUNT] = {">=\$(=vTXNSum)"}>} TXN_AMOUNT)

6 Replies
MVP

May be try like this:

=Sum({<EFF_DATE ={"<=\$(=vMaxTransactionDate)>=\$(=vMinTransactionDate)"}, [TXN_AMOUNT] = {">=\$(=vTXNSum)"}>} TXN_AMOUNT)

Contributor II
Author

Thank you, I'm checking on the expression now, I also want to add Fabs in the set analysis but am having troubles with that also-   can you assist with that also ?

Sum({<EFF_DATE ={"<=\$(=vMaxTransactionDate)>=\$(=vMinTransactionDate)"}, [TXN_AMOUNT] =

{"=fabs(TXN_AMOUNT)"} = ">=\$(=vTXNSum)"}>} TXN_AMOUNT)

MVP

May be this:

Sum({<EFF_DATE ={"<=\$(=vMaxTransactionDate)>=\$(=vMinTransactionDate)"}, [TXN_AMOUNT] = {"=fabs(TXN_AMOUNT) >= vTXNSum"}>} TXN_AMOUNT)

Contributor II
Author

Sunny T ,

This is great thank you- I am still having troubles, although I agree this looks correct

when I break the expression up in an if it works but converting to Set analysis does not give me results

I am looking into the possibility of dates HH MM SS not working well in Set Analysis when using variables for Dates without HH MM SS??? not sure if anyone has ever run into this problem

MVP

I am not sure what you have behind those variables, but a good place to start would be here:

Contributor II
Author

Everything worked perfectly once I adjusted the date format- thanks for your help

Community Browser