Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
@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 )
)
@
hi
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%') & ')'