SQL Manipulation with a VB Net Variable
Hello, Does anyone know an effective way to alter the amount column of a table using a SQL script? Use case: the client is bringing in what they call "Production Downtime" to the system, which show...
Forum Discussion
Hi,
There are a number of ways you can crack this nut. As you are using a Dashboard Dataset rule you can manipulate the contents of the dataset returned by your SQL query before returning it to the data adapter which feeds into the BI Viewer report. The other option is to create calculated fields directly in the BI Viewer dataset to represent the ratio and apply this to a new calculated amount i.e. RatioAmount
Hello,
Since I am not the most proficient SQL, I tried the calculated field in the BI Viewer itself.
A few issues I am having:
- The BI Viewer does not have a "Day in Month" but has a "Day in Week" and "Day in Year". I may be able to combine a few to get to "Day in Month" instead.
- I need the calculated field to ONLY apply to prior year actuals IF the user is in the current month of the year. I'm not sure how the system would understand when to apply the calculated field to the PY data unless I used business rule type logic.
