topic Re: How to make a number static ? in App Development

How to make a number static ?

Anonymous — Mon, 09 Jul 2018 07:22:15 GMT

Hi All,

Would like to ask how to make the number 2678400 static ?

The formula that was given to me is this :

(86400*(sum({$<[DATETIME.autoCalendar.Date]={">=$(=YearStart(Max([DATETIME.autoCalendar.Date]), 0))<=$(=YearEnd(Max([DATETIME.autoCalendar.Date]), 0))"}>*<TECHNOLOGY = {'2G'}>} CELLNUMBER)))

Regards,

Mahirah

Re: How to make a number static ?

petter — Mon, 09 Jul 2018 07:27:41 GMT

You have to explain what you mean by static ...

If you want to have it used multiple places you can put the calculation into a variable or a master measure.

Re: How to make a number static ?

avinashelite — Mon, 09 Jul 2018 07:37:35 GMT

Static in the sense you don't want this number to change ...even when you make selection ?? in that case try like this

(86400*(sum({1<[DATETIME.autoCalendar.Date]={">=$(=YearStart(Max([DATETIME.autoCalendar.Date]), 0))<=$(=YearEnd(Max([DATETIME.autoCalendar.Date]), 0))"}>*<TECHNOLOGY = {'2G'}>} CELLNUMBER)))

Re: How to make a number static ?

Anonymous — Mon, 09 Jul 2018 07:38:24 GMT

By what I meant static is :

if select any of the option on the left whether it is region , technology, category, etc , the number will stay static.

and I just want to use it to divide by a certain category.

Re: How to make a number static ?

Anonymous — Mon, 09 Jul 2018 07:48:35 GMT

Hi Avinash,

Seems like it doesn't work, everytime i clicked on any of the selection.

Re: How to make a number static ?

immkhan2 — Mon, 09 Jul 2018 08:10:59 GMT

Use the required formula in Variable and use afterwards where-ever required.

Re: How to make a number static ?

avinashelite — Thu, 12 Jul 2018 10:58:16 GMT

Try like this

(86400*(sum({1<[DATETIME.autoCalendar.Date]={">=$(=YearStart(Max({1}[DATETIME.autoCalendar.Date]), 0))<=$(=YearEnd(Max({1}[DATETIME.autoCalendar.Date]), 0))"}>*<TECHNOLOGY = {'2G'}>} CELLNUMBER)))