Comments
-
I got confirmation that for the custom summary number to work, it has to be a value field, not a text field. Here's what I figured out: If you want to use a date alone as a summary number, I figured out a way to trick the system to recognize the date as a value with the following beast mode calc: CONCAT( 'Latest Week…
-
One correction...I see that I can string two fields together, and that will export cleanly, if I don't use html for any additional formatting. One additional quirk: It looks like I can't have a date field as a first or only field in the custom summary number. But, if I string a value field first, together with a date field…
-
Hello @ST_-Superman-_ ! Thanks for providing the detailed solution. Good to know that it can be done and to see the logic used to create this. (And, yes, your assumptions about my data table structure are correct.) I have two questions, if you don't mind me asking. ? While I am familiar with SQL basics, I have not used…
