3 Replies Latest reply on Jul 3, 2018 5:15 AM by Jim Dehner

# hi could any one explain how this two formula's are working { FIXED [Customer Name], [Category] : MIN(IF [Category] = 'Furniture' OR [Category] = 'Office Supplies' THEN 1 ELSE 3 END )}

And

[Calcul 2]:

IF  { FIXED [Customer Name] : SUM([Calcul 1]) } = 2 THEN 'OK' ELSE 'NOT' END

Thanks

Anjali

• ###### 1. Re: hi could any one explain how this two formula's are working { FIXED [Customer Name], [Category] : MIN(IF [Category] = 'Furniture' OR [Category] = 'Office Supplies' THEN 1 ELSE 3 END )}

Hi Anjali,

I can only see one calculation there, for

IF  { FIXED [Customer Name] : SUM([Calcul 1]) } = 2 THEN 'OK' ELSE 'NOT' END

For every customer Name, they are working out the sum of calcul 1, and for each customer name, it will assign an 'OK' value if it is equal to 2, otherwise it will be a 'Not'

Thanks,

Mavis

• ###### 2. Re: hi could any one explain how this two formula's are working { FIXED [Customer Name], [Category] : MIN(IF [Category] = 'Furniture' OR [Category] = 'Office Supplies' THEN 1 ELSE 3 END )}

Hi Anjali B,

Break it down and you will get what exactly you are trying to do .

{ FIXED [CUSTOMER NAME], [CATEGORY] : MIN(IF [CATEGORY] = 'FURNITURE' OR [CATEGORY] = 'OFFICE SUPPLIES' THEN 1 ELSE 3 END )}

start with IF function - if category is furniture or office supplies assign 1  else 3 .

Then min function - it will choose the min of 1 , 3 .

then Fixed (LOD ) function :: you are calculating this min for customer name and category means you are calculating the min for each customer -> category .

For 2nd function :

IF  { FIXED [Customer Name] : SUM([Calcul 1]) } = 2 THEN 'OK' ELSE 'NOT' END

For every customer Name, they are working out the sum of calcul 1, and for each customer name, it will assign an 'OK' value if it is equal to 2, otherwise it will be a 'Not' (same explanation  as Mavis Liu )

-Nikher Verma

• ###### 3. Re: hi could any one explain how this two formula's are working { FIXED [Customer Name], [Category] : MIN(IF [Category] = 'Furniture' OR [Category] = 'Office Supplies' THEN 1 ELSE 3 END )}

Good morning

First understand how Fixed LOD work - they form combinations of all the dimensions that precede the colon(:) than performs the aggregation calculation for what follows.

They are con aggregates in themselves so can be used in further calculations

so you first formula is going to make all the permutations of customer name and  category - and for each of them it will assign a 1 when the category is furniture or office supplies - for any other category it assigns a 3  - I am guessing this is the calcu 1 you use in the nexed lod

in the second LOD for each customer name sum the values from the first LOD 9 remember that LOD's are not aggregates so they can be further aggregated)

what the 2 together will do is if the onl customer purchased from the furniture and from the office supply category it will return an OK if they purchased from any other combination of categories then it will return NOT

IF  { FIXED [Customer Name] : SUM([Calcul 1]) } = 2 THEN 'OK' ELSE 'NOT' END

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.