Need help with statement

Questions & Answers
1

CASE WHEN [Company].CurrentMember.Name = ‘Old Mutual’ OR
[Company].CurrentMember.Name = ‘Pick n Pay’ OR
[Company].CurrentMember.Name = ‘Sanlam Life insurance Ltd’ OR
[Company].CurrentMember.name = ‘Digiata’ OR
[Company].CurrentMember.Name = ‘Kaap Agri Bedryf Limited’
THEN
[Measures].[Profit by Expected Close date]*0.33
ELSE
[Measures].[Profit by Expected Close date]
END

I also want to add another parameter to my statement:

I have a custom field called “CF Type”. Within it is four choices

  1. Training
  2. Consulting
  3. System Retainer
  4. Time Retainer

What I am looking for is the Company and the “CF type” fields when they both hit, the data gets piped out. So something like this is what I need, but am failing at as it than only shows the stuff that hit those two parameters but excludes all else?

CASE WHEN [Company].CurrentMember.Name = ‘Old Mutual’ OR
[Company].CurrentMember.Name = ‘Pick n Pay’ OR
[Company].CurrentMember.Name = ‘Sanlam Life insurance Ltd’ OR
[Company].CurrentMember.name = ‘Digiata’ OR
[Company].CurrentMember.Name = ‘Kaap Agri Bedryf Limited’
AND [CF Type].currentMember.Name = ‘Training’ OR
[CF Type].currentmember.Name = ‘Consulting’
THEN
[Measures].[Profit by Expected Close date]*0.33
ELSE
[Measures].[Profit by Expected Close date]
END

2

Hi @Dean1,

Try to put the conditions holding both parameters in parenthesis. That way the OR operator will look at the two condition as one whole condition.

Kind regards,
Roberts // eazyBI support

3

So something like this?

CASE WHEN "***[Company].CurrentMember.Name = ‘Old Mutual’ OR
[Company].CurrentMember.Name = ‘Pick n Pay’ OR
[Company].CurrentMember.Name = ‘Sanlam Life insurance Ltd’ OR
[Company].CurrentMember.name = ‘Digiata’ OR
[Company].CurrentMember.Name = ‘Kaap Agri Bedryf Limited’
AND [CF Type].currentMember.Name = ‘Training’ OR
[CF Type].currentmember.Name = ‘Consulting’***"
THEN
[Measures].[Profit by Expected Close date]*0.33
ELSE
[Measures].[Profit by Expected Close date]
END