Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
I have the following expression in a filter pane
If(((Frac([Order Date]))>=(21/24) OR (Frac([Order Date]))<=(8/24)), 'Night', 'Day')
I wish to add the min function
If(((Frac(min([Order Date])))>=(21/24) OR (Frac(min([Order Date])))<=(8/24)), 'Night', 'Day')
I cant seem to get this to work
please help
May be you need to add TOTAL if you are using this in a chart:
If(((Frac(min(TOTAL [Order Date])))>=(21/24) OR (Frac(min(TOTAL [Order Date])))<=(8/24)), 'Night', 'Day')
or
If(((Frac(min(TOTAL <FieldName>[Order Date])))>=(21/24) OR (Frac(min(TOTAL <FieldName>[Order Date])))<=(8/24)), 'Night', 'Day')
Hiya
the top one seems to be working but, I have not have much luck with this as 'Day' seems to be greyed out
is there a way of converting the below expression to a filter pane?
if(Min(Order_Date)) < Shipment_Date ) or (Min(Order_Date)) > Shipment_Date )) , 'Night' , 'Day')
please help
You mean a list box? What dimension are you finding the min(Order_Date) on? Some sort of id?
Hiya
There is a column called order_date
and there is another order_check
it looks like
order_id , Order_Check, Order_Date
1 1 01/01/2015 19:36
1 2 02/01/2015 09:00
1 3 02/01/2015 09:10
1 4 02/01/2015 09:45
is the order_check 1, I am trying to flag up, as drop down filter pane
please help