Sum Measure Column Values into Texbox when rowno() used

Anonymous — Fri, 22 Jun 2018 15:40:01 GMT

Hi All,

I'm probably not using the right search criteria as I can't find how to Sum the values of a Measure column (in a Table) into a textbox when I have used the RowNo() function to calculate the values.

Here's the scenario, when visiting a client to fix a system the 1st system (row) costs a set amount and includes fixing 5 widgets, any subsequent systems fixed have a reduced cost which includes fixing 2 widgets.

The formula.for the measure column is :

=if(rowno(total) = 1,

250 + (if([Total No of widgets] > 5, ([Total No of widgets]-5)*25, 0)),

80 + (if([Total No of widgets] > 2, ([Total No of widgets]-2)*25, 0))

)

Any pointers appreciated.

Thanks,

Dog.

Re: Sum Measure Column Values into Texbox when rowno() used

sunny_talwar — Fri, 22 Jun 2018 16:16:53 GMT

RowNo() is in context of a chart... a text box can only have a single row... either use Aggr() to create a virtual table... use another criteria to differentiate between 1st row vs other rows

topic Sum Measure Column Values into Texbox when rowno() used in App Development

Sum Measure Column Values into Texbox when rowno() used

Re: Sum Measure Column Values into Texbox when rowno() used