topic Re: Only and Sum used together in App Development

Only and Sum used together

kaylaramsey2 — Wed, 26 Jun 2019 20:22:41 GMT

I'm having trouble getting the Sum for the last five months in a line chart.

Here is the expression I'm using that is not giving me exactly what I need.

=only({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)

I need to add in a Sum(SSENBR) somewhere and I don't know how to do that with 'only'

Any suggestions?

m_woolf — Fri, 11 Jan 2019 19:33:40 GMT

replace Only with Sum?

kaylaramsey2 — Fri, 11 Jan 2019 19:36:45 GMT

When I do that it starts to pull in more than the last five months, which is why I need 'only' or something similar

sunny_talwar — Fri, 11 Jan 2019 20:13:13 GMT

So when you use this

 =Sum({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)

you see data from more than 5 months old... but when you use this

 =only({1<DateDT = {"$(= '>=' & addmonths(Max(EventDTS), -5))"}, Campus = {"Combined"}>} SSENBR)

You see only 5 months of data? Really? Would you be able to share an image with both expressions and may be DateDT as your dimension to show this?