Calculating the Row Total

Efraim

Hi all, Is it possible to get the row total of an algorithm data block?
When I use the rt() formula for data block d (see table below), it seems it's getting the total first of the factors before multiplying them instead of just summing up the result per month.

Layout
Row: Client
Column: Month

Data Block	Data
a	Value
b	FX Rate
c	a*b
d	rt( c )

Hamza Mesbahi

Hi @Efraim,

This is expected behavior. When you apply a total function like rt() to an algorithm, Board evaluates the algorithm at the total level rather than simply summing the displayed values. In other words, it applies the aggregation logic of the referenced blocks before performing the calculation. In your case, that results in the row total of block a multiplied by the row total of block b, rather than simply summing the values in block c.

If want to return a simple sum of the values in block c, you'll need to prevent blocks a and b from being recalculated at the total level. You can do this by changing their summary option from the default Total setting to No Total (for both, a and b), as shown in the screenshots below.

Screenshot 1: change Summary option of a and b to No Total

Screenshot 2: layout config

Screenshot 3: rt(c ) correctly summing block c

Hope this helps.

Kind regards,

Hamza