Hi All,
I need help with developing a report that uses prompt values to create a dynamic calculation.
Please see example below:
Column 1 Column 2 Column 3 Column 4
XYZ (currency based (currency based on
on a prompt value) on a prompt value) (column 2 - column 3
Column 2 and three would be have prompts associated to them for Year and Month. When the user enters the date parameters, Column 4 should calculate the values accordingly.
Any ideas?
Thanks
Hi!
I think you can try to create columns 2, 3, and 4 as query calculations, using a case when statement.
For instance,
column2 = case when year = ?yr? then data item (ie revenue, qty, etc) else 0 end
column3 = case when month = ?month? then data item (ie revenue, qty, etc) else 0 end
column4 = column2 + column4
hopefully, that works..