Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is my expression:
if(
[method]='M-0010' and [parameter]='M0010'
or (isnull(getfieldselections([method])) and isnull(getfieldselections([parameter])))
, avg({<[methode]={"M-0010"}>*<[parameter]={"M0010"}>} [water_quantity]*24/[measure_duration])
,avg([water_quantity]*24/[measure_duration]*[concentration])
)
I want the graph to show the first condition if the selections of [method] and [parameter] are empty or equal to [method]='M-0010' and [parameter]='M0010', it works:
nothing is selected
parameter=m0010 & method=m-0010
However, in other situations the graph doesn't show if I only select a Parameter without selecting the method, it would be empty if i only select let say parameter=S0030. If I want the second condition to show i have to select both parameter and method.
if I delete line: or (isnull(getfieldselections([method])) and isnull(getfieldselections([parameter]))) in the expression, the graph works correctly, but it doesn't fulfill my requirement.
Anybody knows how can I change it?
If that is the case, use "OR" operator instead "AND" operator