Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
Can someone have a look at the attached testproject?
Can anybody explain why this field is not showing up in the bar/line chart while it DOES have values in the pivot table?
Any help is highly appreciated! (and of course some solution or workaround to get it working in my chart as well)
Thanks!
Roberto
Hi,
Before function returns null value for all chart types except pivot table
Refer help option
Sivaraj S
Ah, you're right; i didn't notice that.
Do you have a suggestion for a function that I can use for my purpose?
My calculation for this column is based on outcomes of the previous year (previous record)...
I hope there are possibilities!
What you are tryin to do with first expression(Loan - (remainder))
some of the fields are not there
Try using "above" instead of "before".
Maybe you could use a Set Analysis expression thar returns previous year