Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I'm trying to filter the data by the LOB ID. Please find the attached screen shot.
Thanks in advance.
sum({<LOB_ID ={705,706,713}>}DENOMINATOR)
What is your question?
Hi
Trying to filter the data(i.e., sum(DENOMINATOR) ) by Lob Id
Can you please refer in the screen shot and qvw.file so that you will get an clear idea.
I'm not quite sure what's the question here. Based on your screen shot, LOB 709 doesn't exist in May 2016.
On the other hand, the attached QVW file only contains data for April and June, so it's hard to recreate the same picture.
You may need to explain your problem in more detail - what exactly is wrong?
sorry for the confusion. please exclude LOB 709. The screen shot is just the sample data. You dont have to get the exact values, we have to filter the data by the LOB ID condition.
I still don't understand what your question is. If you need to filter by LOB ID, what's stopping you?
Sorry for the incorrect question. i need to create a expression for that condition.
sum({<LOB_ID ={705,706,713}>}DENOMINATOR)