on 04-07-2017 11:40 AM
Hi guys
In one of the reports developed by my end users, they are having multivalue error in some of the rows where there are more than 1 value for an object:
Here is the sample data":
Yr1 = If( ([start date]<= (RelativeDate('31/03/2017';-365)) And [end date]>= (RelativeDate('31/03/2017';-365)));"Yes";"")Yr2 = If( ([start date]<='31/03/2017' And [end date]>='31/03/2017');"Yes"; "")
Yr1 Price =NoFilter(([price] Where ([Yr1] = "Yes") In ([Key1])) )
Note: there is a filter on report to only show values where Y2 is not null
Yr2 Price = [price] Where ([Yr2] = "Yes") In ([Key1])
[Key1] = [Contract]+[job no]+[skin code].[Contract Id]+[location]
Any ideas guys how to avoid this error?
try this.
Yr2 Price =Sum([price]) In ([skin code])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.