-
1. Re: Basic Calculation off Dimension Attributes?
Deepak Rai
Jun 12, 2018 9:32 AM
COUNT(Complete)/(Count(Pending)+COUNT(Return))
-
2. Re: Basic Calculation off Dimension Attributes?
Hi Deepak,
So "Complete", "Pending", and "Return" are attributes or fields (sorry I dont know the correct terminology) within the dimension "Order Status" so I cannot point a calculated field to those filter names.
For example I have an IF statement where I have to specify what the order status is that says:
IF [Order Status] = 'Closed'
THEN ([Order Number]) END
-
3. Re: Basic Calculation off Dimension Attributes?
Deepak Rai
Jun 12, 2018 9:46 AM
1 of 1 people found this helpfulOrder Status is your Dimension and Closed, Pending, Open Etc are Dimension Values. So If I use This Data To Count Those Orders where status is Complete
Order Number Status 1 Complete 2 Pending 3 Return 4 Complete 5 Return Then you get this
Thanks
Deepak
If it Helps, Pl mark it Helpful and CORRECT to close Thread
-
4. Re: Basic Calculation off Dimension Attributes?
Perfect this is what I needed, appreciate the help
