Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Chart :
I have field : 'Target'
I have expressions 'Total' : Sum( Aggr(if ((INPUT ) >0 ,INPUT , [INTERNAL) - (if(Time(MAX_Finish)= Time_FinishMachine , WorkOrder , '0' )),ID,Start,Shift,Group)*SQFT)
I want The graph shows only Total < Target. What do I have to do?
Hi,
The Show option work with boolean values : 1 for TRUE and 0 for FALSE. The expression looks like :
IF(<your_condition>,1,0).
Regards.
I Try
if( Sum( Aggr(if ((INPUT ) >0 ,INPUT , [INTERNAL) - (if(Time(MAX_Finish)= Time_FinishMachine , WorkOrder , '0' )),ID,Start,Shift,Group)*SQFT) )
<[Target ],1,0)
The chart doesn't show
TRUE and FALSE doesn't show
The issue from your condition expression. You make a comparaison between an aggregate value (calculation) with a non-aggregate value (field).
Add a MIN()/MAX() or ONLY() function on Target (i'm supposing that target is an unique value) and see if it work.
Regards.