Liveware Publishing Support Forum

[updated:LAST EDITED ON Mar-25-05 AT 05:48 PM (EST)]I have a National Sales Report, where i^m summarizing/subtotaling for each client, Group sub totaling on market segment, Group sub totaling on fiscal period... My question is, how would i show YTD totals for each client on the Fiscal Period br...

i did all that, created 3 calc fields... but still have problems:____1. In calc3, else is calc2 and in calc2, else is calc1, what is the "else" clause in calc1??__2. and which calc field do i use for the Group Footer so that i can break on fiscal periods..?____thanks for your help...

IIF(ARRIVAL>={05/01/04} AND ARRIVAL<={05/28/04},8,IIF... and so on. Please explain the calc reference... i tried to do something like that.____thank you very much!

Hi,____I^m setting up a Fiscal periods based on arrival dates, and with the size limitations in a calculated field, i can only set up periods 1-5 in one calulated field (FISCAL1), and periods 6-10 (FISCAL2) and periods 11-12 in (FISCAL3). How can i join (concatenate) these 3 fields (so i can query o...