Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good morning
I need to represent in a chart table the budget month, the month and the previous month based on the month selected from a list box
tell me someone would know the expression to be inserted
thanks
Andrea
my campodata is dataannomese and in my list box, I can select the month with month (dataannomese)
thanks
Andrea
Hi Andrea,
Can you be more specific? What exactly you want to show in a chart table? what were the fields involved or could you please give some sample data?
thanks for the reply.
I want to show the sum of the budget, sending an example attached
For Selected Month:
Sum({<Your_Date_Field={"=Month(Date(Your_Date_Field))"}>}Your_Budget_Field)
For Previous Month:
Sum({<Your_Date_Field={"=Month(Date(Your_Date_Field))-1"}>}Your_Budget_Field)
Hope this helps
Regards,
Manideep
Thanks for the quick response.
I tried to enter the code that you sent me but in the current year and 2 columns last year I see the same value.
thanks
Andrea
Could you please send me the sample Application for better understading