Hi all,
Going mad here as I am sure I've done it before but I could be wrong.
Scenario:
Column A is a case statement to say if the date is max and the status is live, set it to Yes
This works fine, only for the line for the line where the above two statements are true - so this is as expected.
What I'm after is the entire column to say Yes rather than just the lines where they are deemed to be true. Is this possible?
Report is a list report.
Thanks in advance
Quote from: c8aj on 25 Apr 2016 03:59:16 AM
Hi all,
Going mad here as I am sure I've done it before but I could be wrong.
Scenario:
Column A is a case statement to say if the date is max and the status is live, set it to Yes
This works fine, only for the line for the line where the above two statements are true - so this is as expected.
What I'm after is the entire column to say Yes rather than just the lines where they are deemed to be true. Is this possible?
Report is a list report.
Thanks in advance
The entire column? In that case can't you just change the expression of the calculation to 'Yes'? It sounds like you want the word Yes reporting for every row in the report?
Cheers!
MF.
I do want it to say Yes reporting for every row in the report in that specific column but only if one of the rows comes back with the two criteria as being true
Quote from: c8aj on 25 Apr 2016 07:02:44 AM
I do want it to say Yes reporting for every row in the report in that specific column but only if one of the rows comes back with the two criteria as being true
Ah. OK - how about
maximum([your original expression for Column A]) for report)
Cheers!
MF.
Sometimes the simplest solutions are the best. I did not even think about the fact that given Yes comes after No in the alphabet, a simple max would sort it out so thanks for kicking my brain in gear.
I have tried and it seems fine - just waiting to hear back from the customer whether this works or not for them
thanks again!