Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to calculate expression.It's shows like quotient:
onefield/secondfield
I need to calculate it in YearToDate type.
Dividend increase separately than divider.But i need to get a sum of mounthly quotient in yeartodate type.How can i get it?
i try to use this formula:
Sum({<Date={'$(<=vMaxDate)'}>}Aggr($(vQuotient),[Nomenclatura]))
| Nomenclatura | Quotient |
|---|---|
| type1 | 350 |
and last question,thx for helping!
how leave only one column with data,so that data changes with selection and data will be YearToDate?
i mean like in your last example,except all column just one..becouse in your example if i choise one month,like a febrary,table show you only febrary value,not YearToDate...
Thanks a lot!
Haha, it was a little error, the sum was lacking the MonthYear=. Just add it to the first expression, like this:
Sum( {<Date={"<=$(vMaxDate)"}, Month=,MonthYear=>}
Aggr(
Sum( {<Date={"<=$(vMaxDate)"}, Month=,MonthYear=>} OneField)
/
Sum( {<Date={"<=$(vMaxDate)"}, Month=,MonthYear=>} SecondField)
,MonthYear)
)