
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 )}
Mavis Liu Jul 3, 2018 4:28 AM (in response to anjali b)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 )}
nikher verma Jul 3, 2018 4:47 AM (in response to anjali b)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 )}
Jim Dehner Jul 3, 2018 5:15 AM (in response to anjali b)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.