Now I also have three Variables, vDecider, vDays and vType. vDays can take values of 90,180 and 365. vType can take values of General,L1 and L2. vInp is a dynamic variable that can take any numeric value.
Let's say vType=General,vDays=90 and vDecider=300, then I'd like to sum the field Value90 where Decider field<=300 and the output should be 159000.(1st+4th+5th+6th fields). Similarly, if vDays=180 then sum Value180 field where Decider<=300 and so on.
Now if vType='L1', vDays=90 and vDecider=300, then I'd like to sum the field Value90 where Type is only C and Decider Field<=300 and the output should be 119000(1st+5th+6th field). Similarly, if vDays=180 then sum Value180 field where Decider<=300 and so on.
If vType='L2', vDays=90 and vDecider=300 then sum the field Value90 where Type is only N and Decider field<=300 and the output should be 40000(5th field only should be selected).Similarly, if vDays=180 then sum Value180 field where Decider<=300 and so on.
I'd like to create an expression for getting a measure as mentioned above.I have tried nested IF loops but they are not working. Any help is much appreciated. TIA!