logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
dsydsy  
#1 Posted : Thursday, May 6, 2021 10:08:42 PM(UTC)
dsydsy

Rank: Member

Groups: Registered
Joined: 2/15/2019(UTC)
Posts: 10
United States
Location: AZ

Was thanked: 1 time(s) in 1 post(s)
Hello again!

I have a request where I need to be able to apply a factor to specific rows or columns of the report output, depending on what the user selects. Say, using the table below, the user wants to add a factor of 1.5 to any ID = 1 and a factor of 0.7 to all results in column C but then also a factor of 1.2 to all results in A, running everything at the same time...


ID A B C
1
2
3


Is there a way to go about doing something like this? I found the example report using the Quantity Factor, but I lack the expertise to use that example get to accomplish the above scenario.

As always, appreciate any and all help, tips, tricks, etc.
epf  
#2 Posted : Friday, May 7, 2021 12:41:47 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
The sample 301 seems to do what you want, it is not so complicated, just understand it:
- create an input value for the report
- change the SQL in the Pre-Load script of your model
dsydsy  
#3 Posted : Friday, May 7, 2021 1:56:20 PM(UTC)
dsydsy

Rank: Member

Groups: Registered
Joined: 2/15/2019(UTC)
Posts: 10
United States
Location: AZ

Was thanked: 1 time(s) in 1 post(s)
Hi there!

Thanks for the reply!

As noted, I had already found the sample report you are referring to. The issue is I do not understand how to take a factor that is applied to a single column for all rows to being able to apply a factor to specific rows or specific columns when selected by the user. Any direction to resources that could help me figure out how to do this would be greatly appreciated!
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.