I have a GI showing shipment lines, I'm grouping by Shipment number. The I want to show the MAX aggregate value for a boolean field on each line, but its not working for every shipment line.
I tried creating an IF formula to display as 1 or 0, but you can't aggregate a formula.
Any ideas?
I have a GI showing shipment lines, I'm grouping by Shipment number. The I want to show the MAX aggregate value for a boolean field on each line, but its not working for every shipment line.
I tried creating an IF formula to display as 1 or 0, but you can't aggregate a formula.
Any ideas?
When you say you are trying to show the MAX aggregate value for a boolean field, do you mean you want to show boolean = true if any of the lines are true, else false if none of the boolean fields are true? If this is not what you are trying to do, I think you will need to provide more information on what you are trying to do.
I have a GI showing shipment lines, I'm grouping by Shipment number. The I want to show the MAX aggregate value for a boolean field on each line, but its not working for every shipment line.
I tried creating an IF formula to display as 1 or 0, but you can't aggregate a formula.
Any ideas?
When you say you are trying to show the MAX aggregate value for a boolean field, do you mean you want to show boolean = true if any of the lines are true, else false if none of the boolean fields are true? If this is not what you are trying to do, I think you will need to provide more information on what you are trying to do.
Yes correct, I would like the field to show true if any of the lines are true, else false if none are true.
See attached pics
I have a GI showing shipment lines, I'm grouping by Shipment number. The I want to show the MAX aggregate value for a boolean field on each line, but its not working for every shipment line.
I tried creating an IF formula to display as 1 or 0, but you can't aggregate a formula.
Any ideas?
When you say you are trying to show the MAX aggregate value for a boolean field, do you mean you want to show boolean = true if any of the lines are true, else false if none of the boolean fields are true? If this is not what you are trying to do, I think you will need to provide more information on what you are trying to do.
Yes correct, I would like the field to show true if any of the lines are true, else false if none are true.
See attached pics
If you are finding your current method is not working, you can use something similar to this:
=iif(sum(cint([BOOLEANFIELD])) > 0, True, False)
You will also need to use the schema field to choose a boolean field to cast the value. Hope this helps.
I have a GI showing shipment lines, I'm grouping by Shipment number. The I want to show the MAX aggregate value for a boolean field on each line, but its not working for every shipment line.
I tried creating an IF formula to display as 1 or 0, but you can't aggregate a formula.
Any ideas?
When you say you are trying to show the MAX aggregate value for a boolean field, do you mean you want to show boolean = true if any of the lines are true, else false if none of the boolean fields are true? If this is not what you are trying to do, I think you will need to provide more information on what you are trying to do.
Yes correct, I would like the field to show true if any of the lines are true, else false if none are true.
See attached pics
If you are finding your current method is not working, you can use something similar to this:
=iif(sum(cint([BOOLEANFIELD])) > 0, True, False)
You will also need to use the schema field to choose a boolean field to cast the value. Hope this helps.
I've setup as attached and having this error attached. What have I got wrong?
Hi
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
