In addition to trying the fixed report size as @Sam_SAS mentioned, I also want to point out this is expected behavior when using precision containers. The general recommendation if you know reports will be viewed on different screen resolutions is to avoid precision containers altogether: https://go.documentation.sas.com/doc/en/vacdc/8.5/vacar/n0mnqoi9thbth1n1u2df70jja2mq.htm#p0s7lu7nbw2od4n1bos2u18fvo7w   For the print issue, screenshots of what you see in the web versus what you see in the PDF output would be useful as well if you're able to provide that. It's not clear to me if the precision container is related here or not.  ... View more

If you are using Visual Analytics 7.5x on SAS 9.4, then I'm afraid you are out of luck here. There is no way I'm aware of to get 100% for the subtotals in that release I'm afraid. This is due to the nature of that automatic calculated subtotals. You would have to do these calculations in your raw data before loading to LASR/Visual Analytics, then they would be have like normal measures rather than calculated aggregations, and would sum the way you are expecting. If you are using SAS Viya however, there is a workaround. The automatic calculated subtotals does behave the same way here as it does in SAS 9.4, BUT there is an aggregated measure function called AggregateTable that will allow us to manually create the same calculation, and get the sum to work the way you would like. To achieve this, you would need to create a calculated item that looks like this. I have substituted your column names so hopefully you can just copy and paste this into a new calculated item: Sum [_ByGroup_] ('Parc actif'n) / AggregateTable(_Sum_, Table(_Sum_, Fixed('Categorie'n), 'Parc actif'n)) The first part, Sum [_ByGroup_] ('Parc actif'n), is just the normal sum for each Categorie/Operatuer combination. The second part, AggregateTable(_Sum_, Table(_Sum_, Fixed('Categorie'n), 'Parc actif'n)) is the sum of just the Categorie data item.  And of course dividing the two gets us the subtotal.   Then when you turn on subtotals in the crosstab, it should get you that 100%. I've mocked up an example here using the SASHELP.CARS data with Origin, Type, and MSRP so you can see the difference:     Hopefully that helps you out!   ... View more

It is tricky as @Sam_SAS notes but it can be done. The overall process would look something like this: 1. Create your slider as normal 2. Create a calculated item using the TreatAs function to convert the Date to a numeric value. This is necessary to make sure parameters get set correctly later. 3. Change the default aggregation of this calculated item to Average instead of the default Sum. 4. Add two drop down lists, both with the same Date item as your slider. 5. For both drop down list options, set it to Required. 6. For both drop down lists, add a new parameter. One parameter is Minimum Date, the other parameter is Maximum Date. 7. For the drop down list that represents Minimum Date, set a Rank with Bottom Count of 1 and the By your Date Numeric calculated item. 8. For the drop down list that represents Maximum Date, set a Rank with Top Count of 1 and By your Date Numeric calculated item. 9. Create a filter interaction from the slider to both drop down lists.    The end result is as you change the slider, the drop down lists get updated to the respective min/max values and get set in the parameters. Then you can use the parameters however you'd like. You can also hide the drop down lists via a precision container if you'd like.  ... View more

No problem at all!  In this case, you need to explicitly use that "Format" function within your calculated item. This function is what converts the Date type to a Character type. Try this: 1. Create a new calculated item. 2. Click the "Text" button to switch it over to Text view instead of Visual view. 3. Copy this text in: Format('End_Month'n[Raw], 'MMDDYY8.') It should look something like this:   See if that gets you closer. If you need to change the format from MMDDYY8. to something else, you certainly can.    ... View more

That's pretty unusual. Is there anything different this user is doing from other users, like accessing in a different web browser or on a mobile device? What happens if they clear their browser cache? Can they try accessing using a private/incognito browser tab?  ... View more

Are you getting an error when you try to set a format and press OK? I'm not able to tell what is wrong here. Generally all you should have to do here is pick the appropriate format (guessing MONNAME in your case) and click OK, then OK again to save the calculated item, then hopefully that should be that. ... View more

Ah, right everything needs to be the same data type. Since Month is a Date type data item, you can convert it by creating a new calculated item and use the "Format" function. The Format function will take whatever numeric or date value you provide (Month in this case), and the corresponding format of that value, and return it as a character type.  Then you would use that calculated item in the If/Then statement. Hopefully that gets you going! ... View more

In order to import data to LASR, users must have an account on the operating system. This is described here: https://go.documentation.sas.com/doc/en/bicdc/9.4/vaag/n1qzydpsie8xr0n0zddgk8m309l1.htm#p1mhx8msdy8w7dn1bjf3thnpawv6 Unfortunately you will not be able to use an internal metadata user for this.  ... View more

One point I am not clear on here - is the Excel file with the list of bankrupt ID getting loaded into CAS at all? Or is the idea the client has this list, looks at it, and manually goes through the report to filter by the IDs they see inside of this Excel file - so we're trying to find the most efficient way to do that? If the Excel file is not getting loaded to CAS at all, one possibility is to do something like this: - Get the bankrupt IDs in a single comma separated line, like ID1,ID2,ID3, etc - The report needs to have a List Control with a list of all IDs, and a Character List parameter needs to be assigned to the List Control - Generate a URL to the report that includes this parameter. This can be done in the Copy Link dialog for the report: - When ready execute the URL, paste the list of IDs at the end of this URL and execute. One major downside to this approach though is that if the list of IDs is long enough then you may exceed URL length limits (i.e. if the list pushes this past 32K characters) and we cannot get past that.      Otherwise, if the Excel file gets loaded into CAS, could you simply create another List Control where the source is this Excel file and map this datasource to your main datasource with this ID value? The client would then just need to open the report, the List Control would already have all of the bankrupt IDs displayed there, then the client would right-click, select all, and the report would be filtered for the bankrupt IDs? Or - is it possible to do this work outside of Visual Analytics by taking the Excel file and running a job that joins it with the main datasource to create a new datasource that's just for the bankrupt IDs, and then build a report off of that? That way the client would not really need to do anything beyond provide you with the Excel file and then open this report.  ... View more

I think maybe the calculation is a bit flawed here. I assume there are instances where Academic_Student_Status'n = 'Fail' so in addition to PC_ADM_PRS_ID values, you are getting 0 returned for that calculation, and that is getting included in the Distinct count. In other words you are getting a 540 values for PC_ADM_PRS_ID, and then 0, for a total of 541 distinct values. If you are just using this in a single Key Value object, what I think you should probably do instead is just create a single calculated item for the Distinct Count of PC_ADM_PRS_ID: Distinct [_ByGroup_] ('PC_ADM_PRS_ID'n[Formatted]) Add that to the Key Value object, and then add a local filter on the Key Value object for Academic_Student_Status'n In ('Pass','Pass_after_SecondExam'). Meaning - click the Key Value object, click the Filters pane on the right hand side, add this filter.      Otherwise if you already doing some kind of filtering that I'm not seeing - another possibility is if there happens to be a missing value somewhere in the PC_ADM_PRS_ID data item, then Distinct by default includes this in the count.  If that's the case, you might you might be able to account for this in your calculation by adding a second IF statement to check for missing. Something like this (note this is not exact, just freehand typing into this to illustrate the point): Distinct [_ByGroup_] (( IF ( 'Academic_Student_Status'n In ('Pass', 'Pass_after_SecondExam') ) RETURN (IF ('PC_ADM_PRS_ID'n[Formatted] NotMissing)                      RETURN 'PC_ADM_PRS_ID'n[Formatted]                     ELSE 0)) ELSE 0 )) Not sure which VA version you have but there is a property to control this that you or your Administrator can set, and here are the steps for Viya 3.5: 1. Log in to SAS Environment Manager as an Administrator 2. Go to Configuration > All Services > Report Data service 3. Edit the "sas.reportdata.properties" section, and find the property "ignoreMissingValuesInCountDistinct".  4. Turn this one on, save changes, and restart the Report Data service.    For Viya 4 the steps are very similar. For SAS 9.4 this property is in SAS Management Console in the Application Management > SAS Application Infrastructure > Visual Analytics 7.5 properties, and requires a restart of SASServer12_1.  ... View more

I think there's going to be a problem though in how @tijanagilic wants to display this. Getting the calculated value isn't going to be too difficult, but displaying it as another row/column after TEKUCI I don't think is possible. You can only create it as a new measure, which means it will show up as a column next to # (and thus appear twice in the crosstab, once for PRETHODNI and once for TEKUCI) rather than next to TEKUCI as a single column.  I don't know what the column is called that contains both PRETHODNI and TEKUCI so I'm just going to call it Column but what I might recommend doing to get the visual you want is the following: 1. Create two new calculated items to represent the value of # for both PRETHODNI and TEKUCI: If Column IN (PRETHODNI) RETURN # ELSE 0 and If Column IN (TEKUCI) RETURN # ELSE 0   Now you have two new measures, we'll say Prethodni # and Tekuci #.   2. Create a third calculated item for the difference: Prethodni # - Tekuci # 3. In your crosstab, take out Column and #, and instead use the three new measures we created.    If I've misunderstood something though let me know. ... View more