Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a trend line , I like to make it able to display the trend line , when i click on month = 7.
Paul
Hi Robert
Thank you for sharing with me John explaination on SET analysis which is 3 year back.
Paul
You're right, I worked on the reason why the calculation was not calculated for every month. I used internal expressions without modification thinking they were correct.
Here the expression with the internal correction of Kush and my reorganization:
If(sum({<month=>}STK_CLOSE) > 0 and sum({<month=>}STK_OPEN) > 0,
If(Mod(RowNo(),12) = 0, 12, Mod(RowNo(),12)) * 30
*
RangeAvg(Sum({<month=>}TOTAL <year> If([YearMonth] = YearStart([YearMonth]), STK_OPEN)), sum({<month>}STK_CLOSE))
/
RangeSum(Above(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS+COGS_INT_)/1), 0, RowNo()))
)
Thanks Paul.
I am from India
Hi Kush
Are you work in India also ?
Paul
Sent from my iPhone
Yes, I work here in India.