Hi, I would like to divide two CountDistinct formulas together and show the result to 2 decimal places. I have set the TextBox text format to Number with 2 decimal places. However the result is rounding down to the nearest whole number, showing the 2 decimal places as zeros. This is the formula I am...

Basically I am having trouble writing the 'Condition' part of a SumIf summary formula (see screenshot). In the condition I am trying to match column values to a variable . I have checked that the data types are the same in the column and the variable. The example report I sent through has some formu...

Hi, sample report attached. I am aware that there are other ways of solving this problem using filters and bands etc but I would like to solve this entirely within each expression as both a learning exercise and since it aligns with my real-life requirement. I would like each text box in FooterBand1...

Hi, I am trying to write a conditional SumIf expression where the condition compares column values to a variable . I have gotten as far as the below expression, which returns the value zero. Can anyone please let me know where I have gone wrong? {SumIf(DataSource2. Sales ,DataSource2. WeekEndingDate...

Hi sample report is attached. I would like to have the cross tab inside the regular group footer (with the new page before property ticked) so that I can group the cross tab by the regular grouping as well.

Thanks

Thanks that helped a lot! Now I have a new situation where I want to group by page again but I have a cross-header band and a cross-group footer on the page too (that I want included in the page by page grouping). When I go to put my regular group footer on the page it won't go below my cross-header...

Hi, is it possible to have my grouping by grouping condition occur on each page - in other words, so that each item I am grouping by has its own page in my report?

Thanks