I have a column chart in which I want to display the % of Invoiced Sales in 24 hours and % of Not Invoiced Sales in 24 hours. The data should be categorized by date, so for each date I can see the % of invoiced and not invoiced sales within 24
My dataset contains: sales id, sales status (only invoiced are permitted and I took care of that in my query), date and I have the nbDays which is bound to a function that determinate if the sale is invoiced in 24h. So if the nbDays
< 3 it's in 24h otherwise it's not.
I want my chart to display for each date two column: 1- for invoiced in 24, 2- not invoiced in 24 h. So, I drag the date fields to Category fields area and sales id twice to Data fields area. The idea is to use one for invoiced in 24h and the other is for
the other case.
So, I want to know how can I write a conditional expression to get this requirement done and make the data fields sales id displays data according to my condition: I tried this but it didn't work:
=count(iif(fields!nbDays.value <3, 1,0)) and also the:
=iif(fields!nbDays.value <3, count(fileds!salesid.value),0)
any suggestions will be welcomed and appreciated...
View Complete Post