topic Re: Concatenate two measure in same table row in App Development

Concatenate two measure in same table row

johnnyjohn — Mon, 23 Nov 2020 10:42:09 GMT

I have a measure of sales for one week, that looks like

sum({<date= {">=$(=Date(weekstart(Today()-7)))<=$(=Date(weekend(Today()-7)))"}, Record_Type={'M'}>} Gross_Consideration_Eur )

and for another week that looks like

sum({<date= {">=$(=Date(weekstart(Today()-14)))<=$(=Date(weekend(Today()-14)))"}, Record_Type={'M'}>} Gross_Consideration_Eur )

I want the row in a table to look like "200 (50%)" where 200 is the sum of sales for the most recent week and the (50%) comes from the percentage increase of one week to another, how do I concatenate these two values into one measure and format it properly?

Re: Concatenate two measure in same table row

Kushal_Chawda — Mon, 23 Nov 2020 12:28:23 GMT

@johnnyjohn try below

=Dual ( sum({<date= {">=$(=Date(weekstart(Today()-7)))<=$(=Date(weekend(Today()-7)))"}, Record_Type={'M'}>} Gross_Consideration_Eur ) & '(' & sum({<date= {">=$(=Date(weekstart(Today()-14)))<=$(=Date(weekend(Today()-14)))"}, Record_Type={'M'}>} Gross_Consideration_Eur ) & ')' , sum({<date= {">=$(=Date(weekstart(Today()-7)))<=$(=Date(weekend(Today()-7)))"}, Record_Type={'M'}>} Gross_Consideration_Eur ) )

Re: Concatenate two measure in same table row

lironbaram — Mon, 23 Nov 2020 12:28:54 GMT

just do it like this ,

= sum({<date= {">=$(=Date(weekstart(Today()-7)))<=$(=Date(weekend(Today()-7)))"}, Record_Type={'M'}>} Gross_Consideration_Eur ) & '(' & num(sum({<date= {">=$(=Date(weekstart(Today()-7)))<=$(=Date(weekend(Today()-7)))"}, Record_Type={'M'}>} Gross_Consideration_Eur )/ sum({<date= {">=$(=Date(weekstart(Today()-14)))<=$(=Date(weekend(Today()-14)))"}, Record_Type={'M'}>} Gross_Consideration_Eur ),'##0.0%') & ')'